public PromotionModel GetPromotionDetails(int id)
{
ShomaRMEntities db = new ShomaRMEntities();
PromotionModel model = new PromotionModel();
var getPromotiondata = db.tbl_Promotion.Where(p => p.PromotionID == id).FirstOrDefault();
if (getPromotiondata != null)
{
model.PropertyID = getPromotiondata.PropertyID;
model.PromotionTitle = getPromotiondata.PromotionTitle;
model.StartDate = getPromotiondata.StartDate;
model.EndDate = getPromotiondata.EndDate;
}
model.PromotionID = id;
return(model);
}
public List <PromotionModel> GetPromotionListDetails(DateTime FromDate, DateTime ToDate)
{
ShomaRMEntities db = new ShomaRMEntities();
List <PromotionModel> lstpr = new List <PromotionModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
FromDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"));
ToDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"));
db.Database.Connection.Open();
cmd.CommandText = "usp_GetPromotionList";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramF = cmd.CreateParameter();
paramF.ParameterName = "FromDate";
paramF.Value = FromDate;
cmd.Parameters.Add(paramF);
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "ToDate";
paramC.Value = ToDate;
cmd.Parameters.Add(paramC);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
PromotionModel pr = new PromotionModel();
pr.PromotionTitle = dr["PromotionTitle"].ToString();
lstpr.Add(pr);
}
db.Dispose();
return(lstpr.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public string SaveUpdatePromotion(PromotionModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
string msg = "";
int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0;
if (model.PromotionID == 0)
{
var savePromotion = new tbl_Promotion()
{
PromotionID = model.PromotionID,
PropertyID = model.PropertyID,
PromotionTitle = model.PromotionTitle,
StartDate = model.StartDate,
EndDate = model.EndDate,
CreatedDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")),
CreatedById = userid
};
db.tbl_Promotion.Add(savePromotion);
db.SaveChanges();
msg = "Promotion Details Saved Successfully";
}
else
{
var getNOdata = db.tbl_Promotion.Where(p => p.PromotionID == model.PromotionID).FirstOrDefault();
if (getNOdata != null)
{
getNOdata.PromotionID = model.PromotionID;
getNOdata.PropertyID = model.PropertyID;
getNOdata.PromotionTitle = model.PromotionTitle;
getNOdata.StartDate = model.StartDate;
getNOdata.EndDate = model.EndDate;
getNOdata.CreatedDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"));
getNOdata.CreatedById = userid;
}
db.SaveChanges();
msg = "Promotion Details Updated Successfully";
}
db.Dispose();
return(msg);
}