public static List <SpStatusWiseDtl_Result> GetData(StatusWiseBLL obj)
{
List <SpStatusWiseDtl_Result> StatusResult = null;
using (var dbContext = new BSSDBEntities())
{
var ReqData = dbContext.SpStatusWiseDtl(obj.StatusID, obj.DealerID, obj.AccountId);
StatusResult = ReqData.ToList();
}
return(StatusResult);
}
public static void Update(StatusWiseBLL obj)
{
using (var dbContext = new BSSDBEntities())
{
var Check = dbContext.TblStatus.Where(x => x.StatusID == obj.StatusID && x.AccountId == obj.AccountId && x.DealerId == obj.DealerID).FirstOrDefault();
if (Check != null)
{
Check.StatusName = obj.StatusName;
Check.ShortName = obj.ShortName;
Check.StatusCode = obj.StatusCode;
Check.ModifiedDate = DateTime.Now;
dbContext.Entry(Check).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
}
}
}
public static void Post(StatusWiseBLL Obj)
{
using (var dbContext = new BSSDBEntities())
{
var Check = dbContext.TblStatus.Where(x => x.StatusName == Obj.StatusName && x.DealerId == Obj.DealerID && x.AccountId == Obj.AccountId).FirstOrDefault();
if (Check == null)
{
TblStatu tb = new TblStatu
{
StatusName = Obj.StatusName,
ShortName = Obj.ShortName,
StatusCode = Obj.StatusCode,
DealerId = Obj.DealerID,
AccountId = Obj.AccountId,
IsDeleted = false,
CreationDate = DateTime.Now
};
dbContext.Entry(tb).State = System.Data.Entity.EntityState.Added;
dbContext.SaveChanges();
}
}
}
public void Update(StatusWiseBLL obj)
{
StatusMasterDAL.Update(obj);
}
public void Post(StatusWiseBLL Obj)
{
StatusMasterDAL.Post(Obj);
}
public List <SpStatusWiseDtl_Result> GetData(StatusWiseBLL obj)
{
return(ReportsDAL.GetData(obj));
}
