public ActionResult Search(string[] lanhDao, int tuanLe, string search)
{
KeHoachCT keHoachCT = new KeHoachCT();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
keHoachCT.ListPhongBan = phongBanBussinessService.GetNguoiDungLanhDao();
ViewBag.TuanLe = this.GetListWeek();
ViewBag.KeHoachCT = keHoachCT.ListPhongBan;
KeHoachCTBussinessService ketHoachCTBussinessService = new KeHoachCTBussinessService();
JQueryDataTableParamModel param = new JQueryDataTableParamModel();
param.CanBo = "'" + CurrentUser.Name + "'";
if (lanhDao == null || string.IsNullOrEmpty(lanhDao[0]))
{
param.CanBo = StringExtensions.GetListPhongBanOrLanhDao(keHoachCT.ListPhongBan);
}
else
{
param.CanBo = StringExtensions.GetStringListUser(lanhDao);
}
param.StartDate = DateTimeExtensions.FirstDateOfWeek(DateTime.Now.Year, tuanLe, System.Globalization.CultureInfo.CurrentCulture);
param.EndDate = param.StartDate.AddDays(6);
param.sSearch = search;
//Print day of week
GetDayOfWeek(param.StartDate);
List <KeHoachCongTacModel> listKeHoachCongTacModel = ketHoachCTBussinessService.GetKeHoachCongTac(param);
return(View(listKeHoachCongTacModel));
}
public ActionResult Edit(KeHoachCT keHoachCT, string[] thamdu, string[] chutri)
{
try
{
string userName = CurrentUser.Name;
try
{
KeHoachCTBussinessService ketHoachCTBussinessService = new KeHoachCTBussinessService();
keHoachCT.ThamDu = thamdu;
keHoachCT.ChuTri = chutri;
keHoachCT.TuNgayModel = DateTimeExtensions.ConvertDateTime(keHoachCT.TuNgay);
keHoachCT.DenNgayModel = DateTimeExtensions.ConvertDateTime(keHoachCT.DenNgay);
keHoachCT.UserName = userName;
ketHoachCTBussinessService.EditKeHoachCT(keHoachCT);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
catch
{
return(View());
}
}
public ActionResult Edit(KeHoachCT keHoachCT, string[] thamdu, string[] chutri, string TuanLe)
{
try
{
string userName = CurrentUser.Name;
try
{
KeHoachCTBussinessService ketHoachCTBussinessService = new KeHoachCTBussinessService();
keHoachCT.ThamDu = thamdu;
keHoachCT.ChuTri = chutri;
int tuanLe = !string.IsNullOrEmpty(TuanLe) ? Int32.Parse(TuanLe) : DateTimeExtensions.WeekNumber(DateTime.Today);
var tuanLeData = DateTimeExtensions.FirstDateOfWeek(DateTime.Now.Year, tuanLe, System.Globalization.CultureInfo.CurrentCulture);
keHoachCT.TuNgayModel = tuanLeData;
keHoachCT.DenNgayModel = tuanLeData.AddDays(6);
keHoachCT.UserName = userName;
ketHoachCTBussinessService.EditKeHoachCT(keHoachCT);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
throw ex;
}
}
catch
{
return(View());
}
}
public int Save(KeHoachCT keHoachCT)
{
const string storeName = "st_UpdateKeHoachCT";
const string storeNameThamDu = "st_InsertThamDu";
const string storeNameDeleteThamDu = "st_DeleteThamDu";
int idKeHoach = 0;
using (var conn = new AdoHelper())
{
conn.BeginTransaction();
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@TenKeHoach", keHoachCT.TenKeHoach),
new SqlParameter("@UserName", keHoachCT.UserName),
new SqlParameter("@TuNgay", keHoachCT.TuNgayModel),
new SqlParameter("@TuGio", keHoachCT.TuGio),
new SqlParameter("@DenGio", keHoachCT.DenGio),
new SqlParameter("@DenNgay", keHoachCT.DenNgayModel),
new SqlParameter("@KeHoachCongTac", keHoachCT.KeHoachCongTac),
new SqlParameter("@DiaDiem", keHoachCT.DiaDiem),
new SqlParameter("@MucDo", keHoachCT.MucDo),
new SqlParameter("@LapLai", keHoachCT.LapLai),
new SqlParameter("@Deadline", keHoachCT.Deadline),
};
conn.ExecNonQueryProc(storeName, objectParam);
SqlParameter[] objectDeleteThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
};
conn.ExecNonQueryProc(storeNameDeleteThamDu, objectDeleteThamDu);
if (keHoachCT.ThamDu != null && (keHoachCT.ThamDu.Count() > 0))
{
foreach (var item in keHoachCT.ThamDu)
{
SqlParameter[] objectThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@NguoiThamDu", item),
new SqlParameter("@Kieu", 1),//Tham du
};
conn.ExecNonQueryProc(storeNameThamDu, objectThamDu);
}
}
if (keHoachCT.ChuTri != null && (keHoachCT.ChuTri.Count() > 0))
{
foreach (var item in keHoachCT.ChuTri)
{
SqlParameter[] objectThamDu = new SqlParameter[] {
new SqlParameter("@IdKeHoach", keHoachCT.IdKeHoach),
new SqlParameter("@NguoiThamDu", item),
new SqlParameter("@Kieu", 2),//Chu Tri
};
conn.ExecNonQueryProc(storeNameThamDu, objectThamDu);
}
}
conn.Commit();
}
return(idKeHoach);
}
//
// GET: /PhongBan/
public ActionResult Index()
{
KeHoachCT keHoachCT = new KeHoachCT();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
keHoachCT.ListPhongBan = phongBanBussinessService.GetNguoiDungPhongBan();
keHoachCT.ListPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(keHoachCT.ListPhongBan);
ViewBag.TuanLe = this.GetListWeek();
return(View(keHoachCT));
}
public ActionResult Create()
{
KeHoachCT keHoachCT = new KeHoachCT();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
keHoachCT.ListPhongBan = phongBanBussinessService.GetAllNguoiDung();
keHoachCT.ListPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(keHoachCT.ListPhongBan);
keHoachCT.MucDo = 3;
return(View(keHoachCT));
}
public int AddKeHoachCTCanBo(KeHoachCT keHoach, string[] user)
{
KeHoachCTDataService ketHoachCTDataService = new KeHoachCTDataService();
int result = 0;
foreach (var item in user)
{
keHoach.UserName = item;
result = result + ketHoachCTDataService.Add(keHoach);
}
return(result);
}
// GET: LichTuan/Edit/5
public ActionResult Edit(int id)
{
try
{
KeHoachCTBussinessService keHoachCTBussinessService = new KeHoachCTBussinessService();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
List <KeHoachCT> listkeHoachCT = keHoachCTBussinessService.GetKeHoachForUpdate(id);
KeHoachCT keHoachCT = listkeHoachCT[0];
//Get All User
keHoachCT.ListPhongBan = phongBanBussinessService.GetAllNguoiDung();
//Get List PhongBan
keHoachCT.ListPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(keHoachCT.ListPhongBan);
List <ThamDuModel> listThamDuModel = keHoachCTBussinessService.GetThamDuByIdKeHoach(id);
//Get List KhachMoi
//ThamDu : type =1
keHoachCT.ListKhachMoiThamDu = keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id) == null ?
null : keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id).FindAll(t => t.Kieu == 1);
//ChuTri : type =2
keHoachCT.ListKhachMoiChuTri = keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id) == null ?
null : keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id).FindAll(t => t.Kieu == 2);
//Check and fill selected for User in PhongBan
//ThamDu : type =1
keHoachCT.ListPhongBanThamDu = new List <PhongBan>();
List <PhongBan> listPhongBanThamDuOld = keHoachCT.ListPhongBan;
List <PhongBan> listPhongBanChuTriOld = ListExtensions.DeepCopy(listPhongBanThamDuOld);
List <ThamDuModel> listKhachMoiModel = listThamDuModel.FindAll(t => t.Kieu == 1);
keHoachCT.ListPhongBanThamDu = phongBanBussinessService.CheckSelectedThamDu(listPhongBanThamDuOld, listKhachMoiModel);
//ChuTri : type =2
keHoachCT.ListPhongBanChuTri = new List <PhongBan>();
List <ThamDuModel> listChutriModel = listThamDuModel.FindAll(t => t.Kieu == 2);
keHoachCT.ListPhongBanChuTri = phongBanBussinessService.CheckSelectedThamDu(listPhongBanChuTriOld, listChutriModel);
//Get tuan le
ViewBag.TuanLe = this.GetListWeekEdit(DateTimeExtensions.WeekOfYearISO8601(DateTime.ParseExact(keHoachCT.DenNgay, "dd/MM/yyyy", CultureInfo.InvariantCulture)));
return(View(listkeHoachCT[0]));
}
catch (Exception ex)
{
throw ex;
}
}
// GET: LichTuan/Create
// GET: LichTuan/Edit/5
public ActionResult Edit(int id)
{
try
{
KeHoachCTBussinessService keHoachCTBussinessService = new KeHoachCTBussinessService();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
List <KeHoachCT> listkeHoachCT = keHoachCTBussinessService.GetKeHoachForUpdate(id);
KeHoachCT keHoachCT = listkeHoachCT[0];
//Get All User
keHoachCT.ListPhongBan = phongBanBussinessService.GetAllNguoiDung();
//Get List PhongBan
keHoachCT.ListPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(keHoachCT.ListPhongBan);
List <ThamDuModel> listThamDuModel = keHoachCTBussinessService.GetThamDuByIdKeHoach(id);
//Get List KhachMoi
//ThamDu : type =1
keHoachCT.ListKhachMoiThamDu = keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id) == null ?
null : keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id).FindAll(t => t.Kieu == 1);
//ChuTri : type =2
keHoachCT.ListKhachMoiChuTri = keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id) == null ?
null : keHoachCTBussinessService.GetKhachMoiByIdKeHoach(id).FindAll(t => t.Kieu == 2);
//Check and fill selected for User in PhongBan
//ThamDu : type =1
keHoachCT.ListPhongBanThamDu = new List <PhongBan>();
List <PhongBan> listPhongBanThamDuOld = keHoachCT.ListPhongBan;
List <PhongBan> listPhongBanChuTriOld = ListExtensions.DeepCopy(listPhongBanThamDuOld);
List <ThamDuModel> listKhachMoiModel = listThamDuModel.FindAll(t => t.Kieu == 1);
keHoachCT.ListPhongBanThamDu = phongBanBussinessService.CheckSelectedThamDu(listPhongBanThamDuOld, listKhachMoiModel);
//ChuTri : type =2
keHoachCT.ListPhongBanChuTri = new List <PhongBan>();
List <ThamDuModel> listChutriModel = listThamDuModel.FindAll(t => t.Kieu == 2);
keHoachCT.ListPhongBanChuTri = phongBanBussinessService.CheckSelectedThamDu(listPhongBanChuTriOld, listChutriModel);
return(View(listkeHoachCT[0]));
}
catch
{
return(View());
}
}
public ActionResult Create()
{
KeHoachCT keHoachCT = new KeHoachCT();
keHoachCT.Deadline = DateTime.Now;
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
List <KeHoachCT> listKeHoachCT = new List <KeHoachCT>();
listKeHoachCT.Add(keHoachCT);
ViewBag.Month = this.GetListMonth(DateTime.Now.Year);
var listPhongBan = phongBanBussinessService.GetAllNguoiDung();
var listPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(listPhongBan);
ViewBag.ListPhongBan = listPhongBan;
ViewBag.ListPhongBanDistinct = listPhongBanDistinct;
return(View(listKeHoachCT));
}
public ActionResult Create()
{
KeHoachCT keHoachCT = new KeHoachCT();
keHoachCT.DenNgay = DateTime.Now.ToString("dd/MM/yyyy");
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
List <KeHoachCT> listKeHoachCT = new List <KeHoachCT>();
listKeHoachCT.Add(keHoachCT);
ViewBag.TuanLe = this.GetListWeek();
var listPhongBan = phongBanBussinessService.GetAllNguoiDung();
var listPhongBanDistinct = phongBanBussinessService.GetNguoiDungDistinct(listPhongBan);
ViewBag.ListPhongBan = listPhongBan;
ViewBag.ListPhongBanDistinct = listPhongBanDistinct;
return(View(listKeHoachCT));
}
public int Add(KeHoachCT keHoachCT)
{
const string storeName = "st_InsertKeHoachCT";
using (var conn = new AdoHelper())
{
SqlParameter[] objectParam = new SqlParameter[] {
new SqlParameter("@TenKeHoach", keHoachCT.TenKeHoach),
new SqlParameter("@UserName", keHoachCT.UserName),
new SqlParameter("@TuNgay", keHoachCT.TuNgay),
new SqlParameter("@DenNgay", keHoachCT.DenNgay),
new SqlParameter("@KeHoachCongTac", keHoachCT.KeHoachCongTac),
new SqlParameter("@ThamDu", keHoachCT.ThamDu),
new SqlParameter("@DiaDiem", keHoachCT.DiaDiem),
new SqlParameter("@MucDo", keHoachCT.MucDo),
new SqlParameter("@LapLai", keHoachCT.LapLai),
};
return(conn.ExecNonQueryProc(storeName, objectParam));
}
}
public ActionResult Index()
{
KeHoachCT keHoachCT = new KeHoachCT();
PhongBanBussinessService phongBanBussinessService = new PhongBanBussinessService();
keHoachCT.ListPhongBan = phongBanBussinessService.GetNguoiDungLanhDao();
ViewBag.TuanLe = this.GetListWeek();
ViewBag.LanhDao = keHoachCT.ListPhongBan;
KeHoachCTBussinessService ketHoachCTBussinessService = new KeHoachCTBussinessService();
JQueryDataTableParamModel param = new JQueryDataTableParamModel();
param.CanBo = StringExtensions.GetVariableSql(CurrentUser.Name);
param.CanBo = StringExtensions.GetListPhongBanOrLanhDao(keHoachCT.ListPhongBan);
param.StartDate = DateTimeExtensions.FirstDateOfWeek(DateTime.Now.Year, DateTimeExtensions.WeekNumber(DateTime.Today), System.Globalization.CultureInfo.CurrentCulture);
param.EndDate = param.StartDate.AddDays(6);
//Print day of week
GetDayOfWeek(param.StartDate);
return(View(ketHoachCTBussinessService.GetKeHoachCongTac(param, "distinct")));
}
public int EditKeHoachCT(KeHoachCT keHoachCT)
{
KeHoachCTDataService ketHoachCTDataService = new KeHoachCTDataService();
return(ketHoachCTDataService.Save(keHoachCT));
}
public int Save(KeHoachCT aggregate)
{
throw new NotImplementedException();
}
public bool Delete(KeHoachCT aggregate)
{
throw new NotImplementedException();
}
public int AddKeHoachCT(KeHoachCT keHoach)
{
KeHoachCTDataService ketHoachCTDataService = new KeHoachCTDataService();
return(ketHoachCTDataService.Add(keHoach));
}
