public Int32 UpdateStatus(int intCityIdno, bool bStatus, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCityMaster objCityMast = (from mast in db.tblCityMasters
where mast.City_Idno == intCityIdno
select mast).FirstOrDefault();
if (objCityMast != null)
{
objCityMast.Status = bStatus;
objCityMast.Emp_Idno = empIdno;
objCityMast.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
/// <summary>
/// To check record existence in CityMaster
/// </summary>
/// <param name="strCityName"></param>
/// <param name="intStateIdno"></param>
/// <param name="intCityIdno"></param>
/// <returns></returns>
public bool IsExists(string strCityName, Int64 intStateIdno, Int64 intCityIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCityMaster objCityMast = null;
if (intCityIdno > 0)///for update
{
objCityMast = (from CM in db.tblCityMasters
where CM.City_Name == strCityName && CM.State_Idno == intStateIdno &&
CM.City_Idno != intCityIdno
select CM).FirstOrDefault();
}
else /// for insert
{
objCityMast = (from nhu in db.tblCityMasters
where nhu.City_Name == strCityName && nhu.State_Idno == intStateIdno
select nhu).FirstOrDefault();
}
if (objCityMast != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete record from CityMaster
/// </summary>
/// <param name="intColrIdno"></param>
/// <returns></returns>
public int Delete(int intCityIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCityMaster objMast = (from mast in db.tblCityMasters
where mast.City_Idno == intCityIdno
select mast).FirstOrDefault();
if (objMast != null)
{
db.DeleteObject(objMast);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
public tblCityMaster GetStateIdno(Int32 cityidno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCityMaster lst = (from cm in db.tblCityMasters where cm.City_Idno == cityidno orderby cm.City_Name ascending select cm).FirstOrDefault();
return(lst);
}
}
public CityViewModel SetRecordinEdit(tblCityMaster tblCity)
{
CityViewModel city = new CityViewModel();
city.ID = tblCity.StateID;
city.CityName = tblCity.CityName;
city.StateId = tblCity.StateID;
return(city);
}
protected void ddlCompFromCity_SelectedIndexChanged(object sender, EventArgs e)
{
CustomTripSheetDAL obj = new CustomTripSheetDAL();
txtTripNo.Text = obj.GetTripNo(Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToInt32(ddlCompFromCity.SelectedValue), ApplicationFunction.ConnectionString()).ToString();
txtTripNo.Focus();
tblCityMaster mt = obj.GEtLocationDetail(Convert.ToInt64(ddlCompFromCity.SelectedValue));
txtPref.Text = Convert.ToString(mt.City_Abbr);
}
public tblCityMaster GEtLocationDetail(long LocIdno)
{
int value = 0;
tblCityMaster objTrip = new tblCityMaster();
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
objTrip = db.tblCityMasters.Where(t => t.City_Idno == LocIdno).FirstOrDefault();
}
return(objTrip);
}
public void SaveUpdateRecord(CityViewModel model)
{
tblCityMaster tblCity = new tblCityMaster();
if (model.ID <= 0)
{
model.ID = _context.tblCityMasters.Any() ? _context.tblCityMasters.Max(x => x.CityID) + 1 : 1;
tblCity.CityID = model.ID;
_context.tblCityMasters.Add(tblCity);
}
else
{
tblCity = _context.tblCityMasters.Where(x => x.CityID == model.ID).FirstOrDefault();
}
tblCity.CityName = model.CityName;
tblCity.StateID = model.StateId;
_context.SaveChanges();
}
/// <summary>
/// Update records in CityMaster
/// </summary>
/// <param name="strCityName"></param>
/// <param name="strAbb"></param>
/// <param name="bStatus"></param>
/// <param name="intCityIdno"></param>
/// <param name="intStateIdno"></param>
/// <returns></returns>
public Int64 UpdateCityMaster(string strCityName, string strCityNameHindi, string strAbb, Int64 intStateIdno, Int64 intCityIdno, bool bStatus, bool bStatusLocation, Int32 empIdno, string GSTIN_No, string Code_Sap, string SACCode, string add1, string add2)
{
Int64 value = 0;
Int32 intCompIdno = 1;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblCityMaster objCityMaster = (from mast in db.tblCityMasters
where mast.City_Idno == intCityIdno
select mast).FirstOrDefault();
if (objCityMaster != null)
{
objCityMaster.City_Name = strCityName;
objCityMaster.City_Abbr = strAbb;
objCityMaster.Emp_Idno = empIdno;
objCityMaster.CityName_Hindi = strCityNameHindi;
objCityMaster.State_Idno = intStateIdno;
objCityMaster.Status = bStatus;
objCityMaster.AsLocation = bStatusLocation;
objCityMaster.GSTIN_No = GSTIN_No;
objCityMaster.sac_Code = SACCode;
objCityMaster.Code_sap = Code_Sap;
objCityMaster.Address1 = add1;
objCityMaster.Address2 = add2;
//objCityMaster.Comp_Idno = intCompIdno;
objCityMaster.Date_Modified = System.DateTime.Now;
if (IsExists(strCityName, intStateIdno, intCityIdno) == true)
{
value = -1;
}
else if (IsCityLimit() == true && bStatusLocation == true)
{
value = -2;
}
else
{
db.SaveChanges();
value = intCityIdno;
}
}
}
return(value);
}
/// <summary>
/// Insert records in CityMaster
/// </summary>
/// <param name="strCityName"></param>
/// <param name="strAbb"></param>
/// <param name="intStateIdno"></param>
/// <param name="bStatus"></param>
/// <returns></returns>
public Int64 InsertCityMaster(string strCityName, string strCityNameHindi, string strAbb, Int64 intStateIdno, bool bStatus, bool bStatusLocation, Int32 empIdno, string GSTIN_No, string Code_Sap, string SACCode, string add1, string add2)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int64 value;
Int32 intCompIdno = 1;
tblCityMaster ObjcityMast = new tblCityMaster();
if (IsExists(strCityName, intStateIdno, 0))
{
value = -1;
}
else if (IsCityLimit() == true && bStatusLocation == true)
{
value = -2;
}
else
{
ObjcityMast.Emp_Idno = empIdno;
ObjcityMast.City_Name = strCityName;
ObjcityMast.City_Abbr = strAbb;
ObjcityMast.State_Idno = intStateIdno;
ObjcityMast.Status = bStatus;
ObjcityMast.CityName_Hindi = strCityNameHindi;
ObjcityMast.AsLocation = bStatusLocation;
ObjcityMast.GSTIN_No = GSTIN_No;
ObjcityMast.Address1 = add1;
ObjcityMast.Address2 = add2;
//ObjcityMast.Comp_Idno = intCompIdno;
ObjcityMast.Date_Added = System.DateTime.Now;
db.AddTotblCityMasters(ObjcityMast);
db.SaveChanges();
value = ObjcityMast.City_Idno;
}
return(value);
}
}
public CityViewModel SetDataOnEdit(tblCityMaster tblCity)
{
return(_cityRepository.SetRecordinEdit(tblCity));
}
