public DeliveryAddressModel.CustEditAddress EditAddress(string custid2, string addrid2, string fname2, string lname2, string tagid2, string Countryid2, string sid2, string cid2, string addr2, string pinid2, string mobile2, string Emailid)
{
DeliveryAddressModel.CustEditAddress Objeditaddr = new DeliveryAddressModel.CustEditAddress();
try
{
string Insertdata = "Update CustomerAddress set Email='" + Emailid + "',FirstName='" + fname2 + "',LastName='" + lname2 + "',TagId='" + tagid2 + "',CountryId='" + Countryid2 + "',StateId='" + sid2 + "',CityId='" + cid2 + "',Address='" + addr2 + "',MobileNo='" + mobile2 + "',PinCode='" + pinid2 + "',DOM='" + dbc.getindiantime().ToString("dd-MMM-yyyy hh:mm:ss") + "' where CustomerId='" + custid2 + "' and Id='" + addrid2 + "'";
int dtdata = dbc.ExecuteQuery(Insertdata);
if (dtdata > 0)
{
Objeditaddr.Response = CommonString.successresponse;
Objeditaddr.Message = CommonString.successmessage;
}
else
{
Objeditaddr.Response = CommonString.DataNotFoundResponse;
Objeditaddr.Message = CommonString.DataNotFoundMessage;
}
return(Objeditaddr);
}
catch (Exception ee)
{
Objeditaddr.Response = CommonString.Errorresponse;
Objeditaddr.Message = ee.StackTrace;
return(Objeditaddr);
}
}
//public DeliveryAddressModel.CustAddress AddAddressV4(string custid, string name, string tagId, string countryId, string sid, string cid, string pincode, string mobile, string Email, string areaid, string area, string buildingid, string building, string buildingNo, string landmark, string others)
public DeliveryAddressModel.CustEditAddress EditAddressV4(string custid, string addrid2, string name, string tagId, string countryId, string sid, string cid, string pincode, string mobile, string Email, string areaid, string area, string buildingid, string building, string buildingNo, string landmark, string others)
{
DeliveryAddressModel.CustEditAddress Objeditaddr = new DeliveryAddressModel.CustEditAddress();
try
{
area = area.Replace("'", "''");
building = building.Replace("'", "''");
landmark = landmark.Replace("'", "''");
others = others == null ? string.Empty : others.Replace("'", "''");
name = name.Replace("'", "''");
buildingNo = buildingNo.Replace("'", "''");
string StateName = "";
string getState = "SELECT StateName FROM [dbo].[StateMaster] WHERE Id = " + sid;
DataTable dtState = dbc.GetDataTable(getState);
if (dtState.Rows.Count > 0)
{
StateName = dtState.Rows[0]["StateName"].ToString();
}
string CityName = "";
string getCity = "SELECT CityName FROM [dbo].[CityMaster] WHERE Id = " + cid;
DataTable dtCity = dbc.GetDataTable(getCity);
if (dtState.Rows.Count > 0)
{
CityName = dtCity.Rows[0]["CityName"].ToString();
}
if (areaid == "-1")
{
string[] para1 = { area, pincode, StateName, CityName, "0", "1", dbc.getindiantime().ToString("dd-MMM-yyyy hh:mm:ss") };
string areadata = "Insert into ZipCode ([Area] ,[zipcode] ,[State] ,[District] ,[IsDeleted] ,[IsActive],[CreatedOn]) Values (@1,@2,@3,@4,@5,@6,@7)select SCOPE_IDENTITY();";
int Val = dbc.ExecuteQueryWithParamsId(areadata, para1);
areaid = Val.ToString();
}
if (buildingid == "-1")
{
string zipcodeid = "";
string getZipCodeId = "SELECT Id FROM [dbo].[ZipCode] WHERE ZipCode = '" + pincode + "' AND Area=" + "'" + area + "'";
DataTable dtZipCodeId = dbc.GetDataTable(getZipCodeId);
if (dtZipCodeId.Rows.Count > 0)
{
zipcodeid = dtZipCodeId.Rows[0]["Id"].ToString();
string[] para2 = { building, pincode, area, zipcodeid, "0", "1", dbc.getindiantime().ToString("dd-MMM-yyyy hh:mm:ss") };
string areadata = "Insert into tblBuilding ([Building] ,[zipcode] ,[Area] ,[ZipCodeId] ,[IsDeleted] ,[IsActive],[CreatedOn]) Values (@1,@2,@3,@4,@5,@6,@7)select SCOPE_IDENTITY();";
int Val = dbc.ExecuteQueryWithParamsId(areadata, para2);
buildingid = Val.ToString();
}
}
string Insertdata = "Update CustomerAddress set Email='" + Email + "',FirstName='" + name + "',TagId='" + tagId +
"',CountryId='" + countryId + "',StateId='" + sid + "',CityId='" + cid + "',MobileNo='" + mobile +
"',PinCode='" + pincode + "',DOM='" + dbc.getindiantime().ToString("dd-MMM-yyyy hh:mm:ss") +
"',BuildingId = " + buildingid + ", AreaId = " + areaid + ",BuildingNo = '" + buildingNo +
"',LandMark = '" + landmark + "',OtherDetail = '" + others +
"' where CustomerId='" + custid + "' and Id='" + addrid2 + "'";
int dtdata = dbc.ExecuteQuery(Insertdata);
if (dtdata > 0)
{
Objeditaddr.Response = CommonString.successresponse;
Objeditaddr.Message = CommonString.successmessage;
}
else
{
Objeditaddr.Response = CommonString.DataNotFoundResponse;
Objeditaddr.Message = CommonString.DataNotFoundMessage;
}
return(Objeditaddr);
}
catch (Exception ee)
{
Objeditaddr.Response = CommonString.Errorresponse;
Objeditaddr.Message = ee.StackTrace;
return(Objeditaddr);
}
}
