public ActionResult GetShareRateSalaryCostByDept(int pageIndex, string pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
var db = new ShareRateSalaryCostDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.UserID,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = pageIndex,
PageSize = Int32.Parse(pageSize),
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetShareRateSalaryCostByDept(baseListParam, 0, list, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public ActionResult ShareRateSalaryCostStaffGetByID(int id) //CustomerID la type(type = 1 la bang ShareRateForPerformanceReportBystaff), vi su dung lai ham cu nen de la CustomerID
{
var baseListParam = new BaseListParam()
{
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.UserID,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var db = new ShareRateSalaryCostDAL();
var result = db.ShareRateSalaryCostStaffGetByID(baseListParam, id);
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult SaveByDept(ShareRateSalaryCost obj)
{
var baseListParam = new BaseListParam()
{
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.UserID,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var db = new ShareRateSalaryCostDAL();
var result = db.SaveByDept(baseListParam, obj);
var msg = result.Message = result.IsSuccess == true ? AppRes.Success : AppRes.ValidateDateIsExist;
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult DeleteShareRateSalaryCostByDept(int id, int idTable)
{
var obj = new ShareRateSalaryCost()
{
ModifiedBy = Global.CurrentUser.UserID,
Id = id,
Type = idTable
};
obj.ModifiedBy = Global.CurrentUser.UserID;
var db = new ShareRateSalaryCostDAL();
var result = db.DeleteShareRateSalaryCostByDept(obj);
var msg = result.Message = result.IsSuccess == true ? AppRes.Success : AppRes.ValidateDateIsExist;
return(Content(JsonConvert.SerializeObject(new
{
result
})));
}
public ActionResult ImportExcel()
{
if (Global.CurrentUser.RoleId != 1 && Global.CurrentUser.RoleId != 28 && Global.CurrentUser.RoleId != 29 &&
Global.CurrentUser.RoleId != 3)
{
HttpContext.Response.Redirect("/AccessDenied/Index");
}
//var listDataChecked = new List<BdImportCustomerCheckExistedResult>();
var type = 1;
var result = new List <ShareRateSalaryCostType>();
if (Request != null)
{
var db = new ShareRateSalaryCostDAL();
var listRow = new List <ShareRateSalaryCostType>();
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
type = Int32.Parse(Request.Form["Type"]);
using (var package = new ExcelPackage(file.InputStream))
{
var currentSheet = package.Workbook.Worksheets;
var workSheet = currentSheet.First();
var noOfRow = workSheet.Dimension.End.Row;
var roleid = Global.CurrentUser.RoleId;
var officePositionId = Global.CurrentUser.OfficePositionID;
var staffId = Global.CurrentUser.UserID;
for (int i = 2; i <= noOfRow; i++)
{
var row = new ShareRateSalaryCostType()
{
Id = i,
OrganizationUnitID = type == 1 ? 0 : Int32.Parse((workSheet.Cells[i, 1].Value ?? 0).ToString()),
StaffId = type == 2 ? 0 : Int32.Parse((workSheet.Cells[i, 1].Value ?? 0).ToString()),
ShareRate = float.Parse((workSheet.Cells[i, 2].Value ?? 0).ToString()),
StartDate = workSheet.Cells[i, 3].Value == null ? DateTime.MinValue : DateTime.Parse((workSheet.Cells[i, 3].Value ?? 0).ToString()),
EndDate = workSheet.Cells[i, 4].Value == null ? DateTime.MinValue : DateTime.Parse((workSheet.Cells[i, 4].Value ?? 0).ToString()),
CompanyId = Int32.Parse((workSheet.Cells[i, 5].Value ?? 0).ToString()),
CreatedBy = Global.CurrentUser.UserID,
ModifiedBy = Global.CurrentUser.UserID,
Status = 1,
Note = workSheet.Cells[i, 6].Value == null ? "" : workSheet.Cells[i, 6].Value.ToString(),
Type = type,
Result = "",
};
row.StartDate = row.StartDate == DateTime.MinValue ? null : row.StartDate;
row.EndDate = row.EndDate == DateTime.MinValue ? null : row.EndDate;
listRow.Add(row);
}
package.Dispose();
}
}
if (type == 2)
{
result = db.ImportShareRateSalaryCostByDept(listRow, Global.CurrentUser.UserID, Global.CurrentLanguage, Global.CurrentUser.RoleId);
}
else
{
result = db.ImportShareRateSalaryCostByStaff(listRow, Global.CurrentUser.UserID, Global.CurrentLanguage, Global.CurrentUser.RoleId);
}
}
}
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[8]
{
new DataColumn(AppRes.StaffIDD),
new DataColumn(AppRes.OrganazationId),
new DataColumn(AppRes.ShareRate),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.CompanyId),
new DataColumn(AppRes.Note),
new DataColumn(AppRes.Result),
});
foreach (var item in result)
{
dt.Rows.Add(
item.StaffId,
item.OrganizationUnitID,
item.ShareRate,
item.StartDate,
item.EndDate,
item.CompanyId,
item.Note,
item.Result
);
}
if (type == 2)
{
dt.Columns.Remove(AppRes.StaffIDD);
}
else
{
dt.Columns.Remove(AppRes.OrganazationId);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
string handle = Guid.NewGuid().ToString();
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
stream.Position = 0;
//data = stream.ToArray();
TempData[handle] = stream.ToArray();
}
return(new JsonResult()
{
Data = new { FileGuid = handle, FileName = Global.CurrentLanguage == 4? "Result.xlsx" : "Ketqua.xlsx" }
});
}
public ActionResult ExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
if (list.filter7 == "1")
{
dt.Columns.AddRange(new DataColumn[7]
{
new DataColumn(AppRes.Staff),
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ShareRate),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.Note),
new DataColumn(AppRes.Company)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(DateTime);
dt.Columns[4].DataType = typeof(DateTime);
dt.Columns[5].DataType = typeof(string);
dt.Columns[6].DataType = typeof(string);
}
else
{
dt.Columns.AddRange(new DataColumn[6]
{
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ShareRate),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.Note),
new DataColumn(AppRes.Company)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(DateTime);
dt.Columns[3].DataType = typeof(DateTime);
dt.Columns[4].DataType = typeof(string);
dt.Columns[5].DataType = typeof(string);
}
var db = new ShareRateSalaryCostDAL();
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.UserID,
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 = new List <ShareRateSalaryCost>();
if (list.filter7 == "1")
{
lstData = db.GetShareRateSalaryCostByStaff(baseListParam, 1, list, out total, out totalColumns);
}
else
{
lstData = db.GetShareRateSalaryCostByDept(baseListParam, 1, list, out total, out totalColumns);
}
foreach (var item in lstData)
{
if (list.filter7 == "1")
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.StaffName == null ? "" : item.StaffName,
Double.Parse(String.Format("{0:###0.##}", item.ShareRate)),
item.StartDate,
item.EndDate,
item.Note == null ? "" : item.Note,
item.CompanyName == null ? "" : item.CompanyName);
}
else
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
Double.Parse(String.Format("{0:###0.##}", item.ShareRate)),
item.StartDate,
item.EndDate,
item.Note == null ? "" : item.Note,
item.CompanyName == null ? "" : item.CompanyName);
}
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "";
switch (list.filter7)
{
case "1":
// code block
excelName = "Ty le share bao cao chi phi luong theo nhan vien.xlsx";
break;
default:
// code block
excelName = "Ty le share bao cao chi phi luong theo phong ban.xlsx";
break;
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
