public string UpdateState(int id, int countryid, string statename)
{
object result = null;
string strReturn = string.Empty;
try
{
etblStateM obj = new etblStateM();
obj = BL_tblStateM.GetSingleRecordById(id);
obj.iCountryId = countryid;
obj.sState = statename;
int i = BL_tblStateM.UpdateRecord(obj);
if (i == 1)
{
result = new { st = 1, msg = "Updated successfully." };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
catch (Exception)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public string AddState(int countryid, string statename)
{
object result = null;
string strReturn = string.Empty;
try
{
etblStateM eObj = new etblStateM();
eObj.iCountryId = countryid;
eObj.sState = statename;
eObj.dtActionDate = DateTime.Now;
eObj.cStatus = "A";
eObj.iActionBy = 1;
int i = BL_tblStateM.AddRecord(eObj);
if (i == 1)
{
result = new { st = 1, msg = "Added successfully." };
}
else
{
result = new { st = 0, msg = "Kindly try after some time." };
}
}
catch (Exception ex)
{
result = new { st = 0, msg = "Kindly try after some time." };
}
strReturn = OneFineRateAppUtil.clsUtils.ConvertToJson(result);
return(strReturn);
}
public static etblStateM GetSingleRecordByGST(string gstFirstTwoDigit)
{
etblStateM eobj = new etblStateM();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = db.tblStateMs.FirstOrDefault(u => u.sStateCode == gstFirstTwoDigit);
if (dbobj != null)
{
eobj = (etblStateM)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
}
return(eobj);
}
//Get Single Record
public static etblStateM GetSingleRecordById(int id)
{
etblStateM eobj = new etblStateM();
using (OneFineRateEntities db = new OneFineRateEntities())
{
var dbobj = db.tblStateMs.SingleOrDefault(u => u.iStateId == id);
if (dbobj != null)
{
eobj = (etblStateM)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, eobj);
}
}
return(eobj);
}
//Add new record
public static int AddRecord(etblStateM eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblStateM dbstate = (OneFineRate.tblStateM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblStateM());
db.tblStateMs.Add(dbstate);
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(etblStateM eobj)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblStateM obj = (OneFineRate.tblStateM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblStateM());
db.tblStateMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retval = 1;
}
catch (Exception)
{
throw;
}
}
return(retval);
}
