public ActionResult Add(VMCampaignAdd model, HttpPostedFileBase file, string MakeID, string StartedDate, int EndingDate)
{
Campaign campaign = new Campaign();
campaign.CampaignID = Guid.NewGuid();
campaign.Title = model.Campaign.Title;
campaign.StartedDate = DateTime.Parse(StartedDate);
campaign.EndingDate = campaign.StartedDate.AddDays(EndingDate);
campaign.Discount = model.Campaign.Discount;
campaign.Status = model.Campaign.Status;
campaign.IsActive = true;
if (file != null && file.ContentLength > 0)
{
string path = Path.Combine(Server.MapPath("~/Assets/img/campaign"), Path.GetFileName(file.FileName));
file.SaveAs(path);
campaign.PictureUrl = Path.GetFileName(file.FileName);
}
Category cat = CategoryDAL.Get();
Guid temp = Guid.Parse(MakeID);
Make make = MakeDAL.Get(x => x.MakeID == temp);
foreach (var m in make.Models)
{
foreach (var p in m.Products)
{
campaign.Products.Add(p);
}
}
CampaignDAL.Add(campaign);
return(RedirectToAction("Index", "Campaign"));
}
public ActionResult GetListReopenCampaign(int pageIndex, string pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
var db = new CampaignDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
if (list.filter7 == "1" && filter.Split('=').Count() > 1)
{
filter = filter.Replace(filter.Split('=')[filter.Split('=').Count() - 1], "1");
}
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = pageIndex,
PageSize = Int32.Parse(pageSize),
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetListReopenCampaign(baseListParam, list, out total);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public virtual void Update(CampaignDataModel campaign)
{
if (campaign.ID > 0)
{
CampaignDAL.Update(campaign);
}
else
{
throw new Exception("Page not found");
}
}
public virtual void Create(CampaignDataModel campaign)
{
CampaignDAL.Create(campaign);
}
public CampaignDataModel Get(int id)
{
return(CampaignDAL.Get(id));
}
public List <CampaignDataModel> GetAll()
{
return(CampaignDAL.GetAll());
}
public List <ActivityDataModel> GetCampaignActivities(int id)
{
return(CampaignDAL.GetCampaignActivities(id));
}
// GET: Admin/Campaign
public ActionResult Index()
{
return(View(CampaignDAL.GetList()));
}
public ActionResult ExportListReopenCampaign(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[6]
{
new DataColumn(AppRes.ErpCampaignID),
new DataColumn(AppRes.ReopenBy),
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ReasonReopenCampaign),
new DataColumn(AppRes.MediaAccount),
new DataColumn(AppRes.TimeReopenCampaign)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(string);
dt.Columns[3].DataType = typeof(string);
dt.Columns[4].DataType = typeof(string);
dt.Columns[5].DataType = typeof(DateTime);
var db = new CampaignDAL();
int?total = 0;
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
list.FromDate = Convert.ToDateTime(DateTime.ParseExact(list.StringFromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
list.ToDate = Convert.ToDateTime(DateTime.ParseExact(list.StringToDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
var lstData = db.ExportListReopenCampaign(baseListParam, list, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CampaignId == null ? "" : item.CampaignId,
item.ReopenBy == null ? "" : item.ReopenBy,
item.OrginizationUnit == null ? "" : item.OrginizationUnit,
item.Reason == null ? "" : item.Reason,
item.Requester == null ? "" : item.Requester,
item.ReopenDate == null ? new DateTime(1, 1, 1) : item.ReopenDate
);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "";
excelName = "ListCampaignReopen.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
