Comments by Murali Vijay

Murali Vijay 17-Jun-14 3:23am View

select prid,new_roi=case when isroi='y' then 'y' when isroi='N' then 'y' else '' end from table_name;

Murali Vijay 16-Jun-14 3:28am View

try this

declare @Company_Code int=5

with CTE
AS( SELECT distinct @Company_Code,
'bc'+ cast(row_number()over(order by customerID asc) as nvarchar(100))as BillCode,
isnull(AddressLine1,'') as AddressLine1,
isnull(AddressLine2,'') as AddressLine1,
isnull(City_Suburb,'') as City_Suburb,
isnull(StateAbbreviation,'') as StateAbbreviation,
Zip_Postcode,
CC.Country_Code,
Phone ,
Phone as phone_ext,
Email,
'' as Fax,
GETDATE() as create_date_time,
'SYSTEM' as create_user_id,
GETDATE() as last_update_date_time,
'SYSTEM' as last_update_user_id

from MTrackDataImport..rawCustomerSISU C

LEFT OUTER JOIN CD_country CC
ON (CC.Company_Code = @Company_Code
AND C.Country = CC.Country_Name))

select BillCode,StateAbbreviation from cte

Murali Vijay 16-Jun-14 3:26am View

Deleted

try this

declare @Company_Code int=5

with CTE
AS( SELECT distinct @Company_Code,
'bc'+ cast(row_number()over(order by customerID asc) as nvarchar(100))as BillCode,
isnull(AddressLine1,'') as AddressLine1,
isnull(AddressLine2,'') as AddressLine1,
isnull(City_Suburb,'') as City_Suburb,
isnull(StateAbbreviation,'') as StateAbbreviation,
Zip_Postcode,
CC.Country_Code,
Phone ,
Phone as phone_ext,
Email,
'' as Fax,
GETDATE() as create_date_time,
'SYSTEM' as create_user_id,
GETDATE() as last_update_date_time,
'SYSTEM' as last_update_user_id

from MTrackDataImport..rawCustomerSISU C

LEFT OUTER JOIN CD_country CC
ON (CC.Company_Code = @Company_Code
AND C.Country = CC.Country_Name))

select BillCode,StateAbbreviation from cte order by BillCode desc

Murali Vijay 16-Jun-14 3:14am View

everything works fine what you have tried in my local also.Go and check whether identity is set or not for column id in your database

Murali Vijay 16-Jun-14 3:06am View

post the code you have tried

Murali Vijay 16-Jun-14 2:57am View

You didn't mention whether you want asc or desc in row_number

Murali Vijay 13-Jun-14 6:19am View

it's because view is not set to your edit controller...

Murali Vijay 12-Jun-14 8:44am View

could you please post your code??

Murali Vijay 6-Jun-14 3:49am View

Deleted

post your partical view code

Murali Vijay 5-Jun-14 8:12am View

Also, don't forget to stringify your json before sending it.

Murali Vijay 5-Jun-14 7:58am View

$.ajax({
//Stuff...
traditional:true,
data: JSON.stringify({ data: values }

});

In controller

public ActionResult test(List<string> data)
{

//return Json(data,JsonRequestBehavior.AllowGet);
return View(data);
}

try this

Murali Vijay 29-May-14 8:18am View

Post your view source code after we can identify where you have done mistake.

Murali Vijay 29-May-14 8:11am View

you have done everything in correct manner.just run the wcf service application and copy the wcf url then add the service reference in web application . then problem will solve.

Murali Vijay 29-May-14 8:04am View

you have done everything in correct manner.just run the wcf service application and copy the wcf url then add the service reference in web application . then problem will solve.

Murali Vijay 29-May-14 7:05am View

if you configure your service give server service path don't give local service address path

Murali Vijay 29-May-14 5:15am View

if you are working in local machine , the service should be in running mode.then only it will
take the service ref or else configure your service in iis

Murali Vijay 29-May-14 3:43am View

Have you configured your service in web server??

Murali Vijay 29-May-14 3:22am View

it's ok

Murali Vijay 29-May-14 3:06am View

Deleted

@model MyContactsRepositoryPattern.Models.ContactsModel instead of
declare like this @model IEnumerable<'location of model';>

Comments by Murali Vijay (Top 19 by date)