private void FetchUploadFileMasterList()
{
if (Session["UploadFileMasterList"] == null)
{
ObjectResult <UploadFileMasterResult> objUploadFileMasterResult = objSP_PRICINGEntities.SP_FETCH_UPLOAD_FILE_MASTER_DETAILS();
List <UploadFileMasterResult> UploadFileMasterResultList = objUploadFileMasterResult.ToList();
List <UploadFileMaster> UploadFileMasterList = new List <UploadFileMaster>();
if (UploadFileMasterResultList != null && UploadFileMasterResultList.Count > 0)
{
foreach (UploadFileMasterResult oUploadFileMasterResult in UploadFileMasterResultList)
{
UploadFileMaster objUploadFileMaster = new UploadFileMaster();
General.ReflectSingleData(objUploadFileMaster, oUploadFileMasterResult);
UploadFileMasterList.Add(objUploadFileMaster);
}
}
Session["UploadFileMasterList"] = UploadFileMasterList;
}
}
public ActionResult PricingDeployment(PricingDeployment objPricingDeployment, string Command, FormCollection collection, HttpPostedFileBase file, HttpPostedFileBase file1)
{
LoginController objLoginController = new LoginController();
List <UploadFileMaster> UploadFileMasterList = (List <UploadFileMaster>)Session["UploadFileMasterList"];
string strEntityID = collection["EntityID"];
string strIsSecuredID = collection["IsSecuredID"];
Int32 intEntityID = Convert.ToInt32(strEntityID.Split(',')[0]);
Int32 intIsSecuredID = Convert.ToInt32(strIsSecuredID.Split(',')[0]);
try
{
if (ValidateSession())
{
bool blnUploadStatus = false;
bool blnUploadDataStatus = true;
#region Price Deployment
if (Command == "PDUpload")
{
if (file != null && file.ContentLength > 0)
{
UploadFileMaster objUploadFileMaster = UploadFileMasterList.Find(delegate(UploadFileMaster oUploadFileMaster) { return(oUploadFileMaster.UploadTypeCode == "PDR"); });
string strFilePath = System.Web.HttpContext.Current.Server.MapPath("~/Uploads/");
string strFileName = Path.GetFileNameWithoutExtension(file.FileName) + DateTime.Now.ToString("dd_mmm_yyyy_hh_mm");
string strExtension = Path.GetExtension(file.FileName);
strFilePath += strFileName + strExtension;
file.SaveAs(strFilePath);
FileInfo newFile = new FileInfo(strFilePath);
string strSourceColumn = objUploadFileMaster.SourceColumn;
string[] arrSourceColumn = null;
if (strSourceColumn != "")
{
arrSourceColumn = strSourceColumn.Split('|');
}
DataTable dtData = new DataTable();
for (int i = 0; i < arrSourceColumn.Length; i++)
{
dtData.Columns.Add(arrSourceColumn[i]);
}
string strDestinationColumn = objUploadFileMaster.DestinationColumn;
string[] arrDestinationColumn = null;
if (strDestinationColumn != "")
{
arrDestinationColumn = strDestinationColumn.Split('|');
}
string strTableName = objUploadFileMaster.TableName;
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[objUploadFileMaster.SheetName];
string strVersion = worksheet.Cell(1, 2).Value.Trim();
if (strVersion == "")
{
strVersion = "0";
}
DataRow drNew;
for (int iRow = 4; iRow < 36; iRow++)
{
if (Convert.ToString(worksheet.Cell(iRow, 1).Value) != "")
{
drNew = dtData.NewRow();
var Days = worksheet.Cell(iRow, 1).Value.Split('-');
var MinDays = Days[0].Trim();
var MaxDays = Days[1].Trim();
drNew["VERSION"] = strVersion;
drNew["ENTITY_ID"] = intEntityID;
drNew["IS_SECURED_ID"] = intIsSecuredID;
drNew["MIN_DAYS"] = MinDays;//worksheet.Cell(iRow, 1).Value;
drNew["MAX_DAYS"] = MaxDays;
drNew["DEPLOYMENT_RATE"] = worksheet.Cell(iRow, 2).Value;
drNew["CREATED_DATE"] = DateTime.Now;
drNew["CREATED_BY"] = 1;
dtData.Rows.Add(drNew);
}
else
{
break;
}
}
}
string strMyConnection = Convert.ToString(System.Configuration.ConfigurationManager.ConnectionStrings["SP_PRICINGConnectionString"]);
if (arrSourceColumn != null && arrDestinationColumn != null && arrSourceColumn.Length == arrDestinationColumn.Length)
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strMyConnection))
{
bulkCopy.DestinationTableName = strTableName;
for (int i = 0; i < arrSourceColumn.Length; i++)
{
bulkCopy.ColumnMappings.Add(arrSourceColumn[i], arrDestinationColumn[i]);
}
bulkCopy.WriteToServer(dtData);
}
blnUploadStatus = true;
DataSet dsIV = new DataSet();
dsIV = General.ExecuteDataSet(objUploadFileMaster.ExtraProcedure);
}
else
{
blnUploadStatus = false;
}
if (blnUploadStatus)
{
ManageUploadFileInfo(0, file.FileName, strFilePath, blnUploadStatus, blnUploadDataStatus);
ViewBag.Message = "Imported successfully";
}
return(View(objPricingDeployment));
}
}
#endregion
#region Actual Deployment
else if (Command == "ADUpload")
{
if (file1 != null && file1.ContentLength > 0)
{
UploadFileMaster objUploadFileMaster = UploadFileMasterList.Find(delegate(UploadFileMaster oUploadFileMaster) { return(oUploadFileMaster.UploadTypeCode == "ADR"); });
string strFilePath = System.Web.HttpContext.Current.Server.MapPath("~/Uploads/");
string strFileName = Path.GetFileNameWithoutExtension(file1.FileName) + DateTime.Now.ToString("dd_mmm_yyyy_hh_mm");
string strExtension = Path.GetExtension(file1.FileName);
strFilePath += strFileName + strExtension;
file1.SaveAs(strFilePath);
FileInfo newFile = new FileInfo(strFilePath);
string strSourceColumn = objUploadFileMaster.SourceColumn;
string[] arrSourceColumn = null;
if (strSourceColumn != "")
{
arrSourceColumn = strSourceColumn.Split('|');
}
DataTable dtData = new DataTable();
for (int i = 0; i < arrSourceColumn.Length; i++)
{
dtData.Columns.Add(arrSourceColumn[i]);
}
string strDestinationColumn = objUploadFileMaster.DestinationColumn;
string[] arrDestinationColumn = null;
if (strDestinationColumn != "")
{
arrDestinationColumn = strDestinationColumn.Split('|');
}
string strTableName = objUploadFileMaster.TableName;
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[objUploadFileMaster.SheetName];
string strVersion = worksheet.Cell(1, 2).Value.Trim();
if (strVersion == "")
{
strVersion = "0";
}
DataRow drNew;
for (int iRow = 4; iRow < 100; iRow++)
{
if (Convert.ToString(worksheet.Cell(iRow, 1).Value) != "")
{
drNew = dtData.NewRow();
var Days = worksheet.Cell(iRow, 1).Value.Split(' ');
var MinDays = Days[0].Trim();
var MaxDays = Days[2].Trim();
drNew["VERSION"] = strVersion;
drNew["MIN_DAYS"] = MinDays;//worksheet.Cell(iRow, 1).Value;
drNew["MAX_DAYS"] = MaxDays;
drNew["DEPLOYMENT_RATE"] = worksheet.Cell(iRow, 2).Value;
drNew["CREATED_DATE"] = DateTime.Now;
drNew["CREATED_BY"] = 1;
dtData.Rows.Add(drNew);
}
else
{
break;
}
}
}
string strMyConnection = Convert.ToString(System.Configuration.ConfigurationManager.ConnectionStrings["SP_PRICINGConnectionString"]);
if (arrSourceColumn != null && arrDestinationColumn != null && arrSourceColumn.Length == arrDestinationColumn.Length)
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strMyConnection))
{
bulkCopy.DestinationTableName = strTableName;
for (int i = 0; i < arrSourceColumn.Length; i++)
{
bulkCopy.ColumnMappings.Add(arrSourceColumn[i], arrDestinationColumn[i]);
}
bulkCopy.WriteToServer(dtData);
}
blnUploadStatus = true;
DataSet dsIV = new DataSet();
dsIV = General.ExecuteDataSet(objUploadFileMaster.ExtraProcedure);
}
else
{
blnUploadStatus = false;
}
if (blnUploadStatus)
{
ManageUploadFileInfo(0, file1.FileName, strFilePath, blnUploadStatus, blnUploadDataStatus);
ViewBag.Message = "Imported successfully";
}
return(View(objPricingDeployment));
}
}
#endregion
#region Pricing Deployment Download
else if (Command == "PDDownload")
{
UploadFileMaster objUploadFileMaster = UploadFileMasterList.Find(delegate(UploadFileMaster oUploadFileMaster) { return(oUploadFileMaster.UploadTypeCode == "PDR"); });
string strFilePath = System.Web.HttpContext.Current.Server.MapPath(objUploadFileMaster.TemplateFileName);
if (System.IO.File.Exists(strFilePath))
{
FileInfo fileinfo = new FileInfo(strFilePath);
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + Path.GetFileName(strFilePath));
Response.AddHeader("Content-Type", "application/Excel");
Response.ContentType = "application/vnd.xls";
Response.AddHeader("Content-Length", fileinfo.Length.ToString());
Response.WriteFile(fileinfo.FullName);
Response.End();
}
return(View(objPricingDeployment));
}
#endregion
return(View());
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
catch (Exception ex)
{
UserMaster objUserMaster = new UserMaster();
objUserMaster = (UserMaster)Session["LoggedInUser"];
LogError(ex.Message, ex.StackTrace, "UnderlyingCreationController", "PricingDeployment Post", objUserMaster.UserID);
return(RedirectToAction("ErrorPage", "Login"));
}
}
public ActionResult HolidayMaster(string Command, HttpPostedFileBase file)
{
if (ValidateSession())
{
}
FetchUploadFileMasterList();
List <UploadFileMaster> UploadFileMasterList = (List <UploadFileMaster>)Session["UploadFileMasterList"];
HolidayMaster hMaster = new HolidayMaster();
if (Command == "PDDownload")
{
UploadFileMaster objUploadFileMaster = UploadFileMasterList.Find(
delegate(UploadFileMaster oUploadFileMaster)
{
return(oUploadFileMaster.UploadTypeCode == "HM");
});
string strFilePath = System.Web.HttpContext.Current.Server.MapPath(objUploadFileMaster.TemplateFileName);
if (System.IO.File.Exists(strFilePath))
{
FileInfo fileinfo = new FileInfo(strFilePath);
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + Path.GetFileName(strFilePath));
Response.AddHeader("Content-Type", "application/Excel");
Response.ContentType = "application/vnd.xls";
Response.AddHeader("Content-Length", fileinfo.Length.ToString());
Response.WriteFile(fileinfo.FullName);
Response.End();
}
}
if (Command == "PDUpload")
{
if (file != null && file.ContentLength > 0)
{
UploadFileMaster objUploadFileMaster = UploadFileMasterList.Find(delegate(UploadFileMaster oUploadFileMaster) { return(oUploadFileMaster.UploadTypeCode == "HM"); });
string strFilePath = System.Web.HttpContext.Current.Server.MapPath("~/Uploads/");
string strFileName = Path.GetFileNameWithoutExtension(file.FileName) + DateTime.Now.ToString("dd_mmm_yyyy_hh_mm");
string strExtension = Path.GetExtension(file.FileName);
strFilePath += strFileName + strExtension;
file.SaveAs(strFilePath);
FileInfo newFile = new FileInfo(strFilePath);
string strSourceColumn = objUploadFileMaster.SourceColumn;
string[] arrSourceColumn = null;
if (strSourceColumn != "")
{
arrSourceColumn = strSourceColumn.Split('|');
}
DataTable dtData = new DataTable();
for (int i = 0; i < arrSourceColumn.Length; i++)
{
dtData.Columns.Add(arrSourceColumn[i]);
}
string strDestinationColumn = objUploadFileMaster.DestinationColumn;
string[] arrDestinationColumn = null;
if (strDestinationColumn != "")
{
arrDestinationColumn = strDestinationColumn.Split('|');
}
string strTableName = objUploadFileMaster.TableName;
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[objUploadFileMaster.SheetName];
string strVersion = worksheet.Cell(1, 2).Value.Trim();
if (strVersion == "")
{
strVersion = "0";
}
DataRow drNew;
for (int iRow = 2; iRow < 36; iRow++)
{
if (Convert.ToString(worksheet.Cell(iRow, 1).Value) != "")
{
drNew = dtData.NewRow();
var Reason = worksheet.Cell(iRow, 1).Value;
var Holiday_Date = DateTime.FromOADate(double.Parse(worksheet.Cell(iRow, 2).Value));
drNew["REASON"] = Reason;//worksheet.Cell(iRow, 1).Value;
drNew["HOLIDAY_DATE"] = Convert.ToDateTime(Holiday_Date);
drNew["VERSION"] = 1;
drNew["ISACTIVE"] = 1;
dtData.Rows.Add(drNew);
}
else
{
break;
}
}
}
string strMyConnection = Convert.ToString(System.Configuration.ConfigurationManager.ConnectionStrings["SP_PRICINGConnectionString"]);
if (arrSourceColumn != null && arrDestinationColumn != null && arrSourceColumn.Length == arrDestinationColumn.Length)
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(strMyConnection))
{
bulkCopy.DestinationTableName = strTableName;
for (int i = 0; i < arrSourceColumn.Length; i++)
{
bulkCopy.ColumnMappings.Add(arrSourceColumn[i], arrDestinationColumn[i]);
}
bulkCopy.WriteToServer(dtData);
}
blnUploadStatus = true;
}
else
{
blnUploadStatus = false;
}
if (blnUploadStatus)
{
ViewBag.Message = "Imported successfully";
}
return(View(hMaster));
}
}
return(View(hMaster));
}