public Int64 Update(DateTime?AlignDate, string LorryNo)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AlignDate_SMS objSMSAlign = (from mast in db.AlignDate_SMS
where mast.AlignDate == AlignDate && mast.LorryNo == LorryNo
select mast).FirstOrDefault();
if (objSMSAlign != null)
{
objSMSAlign.Status = true;
db.SaveChanges();
intValue = objSMSAlign.ID;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public Int64 Insert(string msg, DateTime?AlignDate, DateTime?PrevAlignDate, string LorryNo)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AlignDate_SMS objSMSAlign = new AlignDate_SMS();
objSMSAlign.Message = msg;
objSMSAlign.AlignDate = AlignDate;
objSMSAlign.PrevAlignDate = PrevAlignDate;
objSMSAlign.LorryNo = LorryNo;
objSMSAlign.Status = false;
objSMSAlign.DateModified = System.DateTime.Now;
if (IsExists(LorryNo, AlignDate) == true)
{
intValue = -1;
}
else
{
db.AlignDate_SMS.AddObject(objSMSAlign);
db.SaveChanges();
intValue = objSMSAlign.ID;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
public bool IsExists(string LorryNo, DateTime?AlignDate)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AlignDate_SMS obj = new AlignDate_SMS();
obj = (from mast in db.AlignDate_SMS
where mast.LorryNo == LorryNo && mast.AlignDate == AlignDate
select mast).FirstOrDefault();
if (obj != null)
{
return(true);
}
else
{
return(false);
}
}
}
