public JsonResult FetchPricingDeployment(string Entity, string IsSecured) { try { List <PricingDeployment> PricingDeploymentList = new List <PricingDeployment>(); if (Entity == "") { Entity = "-1"; } if (IsSecured == "") { IsSecured = "-1"; } DataSet dsResult = new DataSet(); dsResult = General.ExecuteDataSet("FETCH_PRICING_DEPLOYMENT", Convert.ToInt32(Entity), Convert.ToInt32(IsSecured)); if (dsResult != null && dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsResult.Tables[0].Rows) { PricingDeployment obj = new PricingDeployment(); obj.Version = Convert.ToInt32(dr["VERSION"]); obj.EntityName = Convert.ToString(dr["ENTITY"]); obj.IsSecuredName = Convert.ToString(dr["IS_SECURED"]); obj.MinDays = Convert.ToInt32(dr["MIN_DAYS"]); obj.MaxDays = Convert.ToInt32(dr["MAX_DAYS"]); obj.DeploymentRate = Convert.ToDouble(dr["DEPLOYMENT_RATE"]); obj.CreatedDate = Convert.ToDateTime(dr["CREATED_DATE"]); PricingDeploymentList.Add(obj); } } var PricingDeploymentListData = PricingDeploymentList.ToList(); return(Json(PricingDeploymentListData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { UserMaster objUserMaster = new UserMaster(); objUserMaster = (UserMaster)Session["LoggedInUser"]; LogError(ex.Message, ex.StackTrace, "UnderlyingCreationController", "FetchPricingDeployment", objUserMaster.UserID); return(Json("")); } }
public ActionResult PricingDeployment(int?ID) { LoginController objLoginController = new LoginController(); PricingDeployment objPricingDeployment = new PricingDeployment(); try { if (ValidateSession()) { #region Menu Access By on Role Int32 intResult = 0; UserMaster objUserMaster = new UserMaster(); objUserMaster = (UserMaster)Session["LoggedInUser"]; var Result = objSP_PRICINGEntities.VALIDATE_MENU_BY_ROLE(objUserMaster.RoleID, "UCPD"); intResult = Convert.ToInt32(Result.SingleOrDefault()); if (intResult == 0) { return(RedirectToAction("UserNotAuthorize", "Login")); } #endregion FetchUploadFileMasterList(); return(View(objPricingDeployment)); } else { return(RedirectToAction("Login", "Login")); } } catch (Exception ex) { UserMaster objUserMaster = new UserMaster(); objUserMaster = (UserMaster)Session["LoggedInUser"]; LogError(ex.Message, ex.StackTrace, "PricingDeploymentController", "PricingDeployment Get", objUserMaster.UserID); return(RedirectToAction("ErrorPage", "Login")); } }
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")); } }