protected void btnUpload_Click(object sender, EventArgs e) { //clearing lblStatusHeading.Text = ""; lblStatus.Text = ""; // btnBeginTrans.Visible = false; pnlErrData.Visible = false; // pnlSummary.Visible = false; DataTable temp = new DataTable(); rptErrData.DataSource = temp; rptErrData.DataBind(); temp.Dispose(); string file_name = ""; //check - file selected if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } if (Session["username"] != null) { username = Session["username"].ToString().Trim(); } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/HathwayChange/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); // btnBeginTrans.Visible = false; return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "( var_lcopre_bulk_custid, var_lcopre_bulk_vcid, var_lcopre_bulk_lcocode, var_lcopre_bulk_old_planname,var_lcopre_bulk_new_planname,"; table_columns += "var_lcopre_bulk_foc1_planname,var_lcopre_bulk_foc2_planname,var_lcopre_bulk_foc3_planname ,var_lcopre_bulk_insby constant \"" + username + "\", var_lcopre_bulk_useruniqueid constant \"" + upload_id + "\", dat_lcopre_bulk_date constant \"" + cur_timestamp + "\", var_lcopre_bulk_file constant \"" + file_name + "\")"; //calling data uploader string uploadresult = helper.cDataUpload("d:\\dataupload\\hathwaychange\\" + username + "\\" + fupData.PostedFile.FileName, "d:\\dataupload\\hathwaychange\\" + username + "\\hathwayctl.txt", "d:\\dataupload\\hathwaychange\\" + username + "\\hathwaylog.log", table_columns, "upassdb", "upass", "cba", "aoup_lcopre_bulk_change_raw", upload_id); //string uploadresult = helper.cDataUpload("d:\\dataupload\\hathwaychange\\" + username + "\\" + fupData.PostedFile.FileName, // "d:\\dataupload\\hathwaychange\\" + username + "\\hathwayctl.txt", // "d:\\dataupload\\hathwaychange\\" + username + "\\hathwaylog.log", // table_columns, "21live", "upass", "cba", "aoup_lcopre_bulk_change_raw", // upload_id); //string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName, // "D:\\DataUpload\\Hathway\\" + username + "\\HathwayCTL.txt", // "D:\\DataUpload\\Hathway\\" + username + "\\HathwayLOG.log", // table_columns, "UPASS_LIVE", "SYSTEM", "cba", "aoup_lcopre_bulk_upload_raw", // upload_id); if (uploadresult == "0") { callprocedure(); } else { if (uploadresult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadresult.ToString(); } } }
protected void btnUpload_Click(object sender, EventArgs e) { //clearing lblStatusHeading.Text = ""; lblStatus.Text = ""; //temp.Dispose(); string file_name = ""; username = Session["username"].ToString().Trim(); //check - file selected if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/Hathway/{0}", username.Trim()); //string directoryPath = string.Format(@"E:/DataUpload/Hathway/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); // btnBeginTrans.Visible = false; return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "(bhubhag_id, bhubhag_name, is_deleted, deleted_on,is_updated, updated_on, updated_by)"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\Hathway\\" + username + "\\HathwayCTL.txt", "D:\\DataUpload\\Hathway\\" + username + "\\HathwayLOG.log", // table_columns, "upassdb", "upass", "cba", "aoup_lcopre_lcoshare_plan", table_columns, "ASBSDB", "bhiwandi", "bhiwandi", "bhubhag", upload_id); if (uploadResult == "0") { callprocedureMst(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadResult.ToString(); } } }
protected void btnconfirm_click(object sender, EventArgs e) { if (txtRemark.Text == "") { MessageAlert("Remark can not blank", ""); return; } if (grdSTBDetails.Rows.Count == 0) { MessageAlert("STB Details not found", ""); return; } DataTable transdetail = (DataTable)ViewState["transdetail"]; string Receipttype = ""; if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("SPSR")) { Receipttype = "SPSR"; } else if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("SPSN")) { Receipttype = "SPSN"; } else if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("PPSN")) { Receipttype = "PPSN"; } else { Receipttype = "PPSR"; } DataTable Tbllist = new DataTable(); Tbllist.Columns.Add("transid"); Tbllist.Columns.Add("orderno"); Tbllist.Columns.Add("lcocode"); Tbllist.Columns.Add("deviceid"); Tbllist.Columns.Add("boxtype"); Tbllist.Columns.Add("type"); Tbllist.Columns.Add("model"); Tbllist.Columns.Add("manufacturer"); Tbllist.Columns.Add("company"); Tbllist.Columns.Add("city"); Tbllist.Columns.Add("state"); Tbllist.Columns.Add("scheameid"); Tbllist.Columns.Add("insby"); Tbllist.Columns.Add("Flag"); Tbllist.Columns.Add("STBID"); String str = ""; for (int i = 0; i < grdSTBDetails.Rows.Count; i++) { RadioButton RdoGood = (RadioButton)grdSTBDetails.Rows[i].FindControl("RdoGood"); RadioButton RdoFaulty = (RadioButton)grdSTBDetails.Rows[i].FindControl("RdoFaulty"); RadioButton RdoUndelivered = (RadioButton)grdSTBDetails.Rows[i].FindControl("RdoUndelivered"); String STBStatus = ""; if (RdoGood.Checked == true) { STBStatus = "G"; } else if (RdoFaulty.Checked == true) { // STBStatus = "F"; STBStatus = "R"; } else if (RdoUndelivered.Checked == true) { STBStatus = "U"; } if (STBStatus == "G") { if (grdSTBDetails.Rows[i].Cells[2].Text == "STB") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Session["username"].ToString(), grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "STB", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "G", grdSTBDetails.Rows[i].Cells[5].Text); } else if (grdSTBDetails.Rows[i].Cells[2].Text == "VC") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Session["username"].ToString(), grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "VC", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "G", grdSTBDetails.Rows[i].Cells[5].Text); } } else if (STBStatus == "R") { if (grdSTBDetails.Rows[i].Cells[2].Text == "STB") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], grdSTBDetails.Rows[i].Cells[6].Text, grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "STB", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "F", grdSTBDetails.Rows[i].Cells[5].Text); } else if (grdSTBDetails.Rows[i].Cells[2].Text == "VC") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], grdSTBDetails.Rows[i].Cells[6].Text, grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "VC", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "F", grdSTBDetails.Rows[i].Cells[5].Text); } } else if (STBStatus == "U") { if (grdSTBDetails.Rows[i].Cells[2].Text == "STB") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], grdSTBDetails.Rows[i].Cells[6].Text, grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "STB", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "U", grdSTBDetails.Rows[i].Cells[5].Text); } else if (grdSTBDetails.Rows[i].Cells[2].Text == "VC") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], grdSTBDetails.Rows[i].Cells[6].Text, grdSTBDetails.Rows[i].Cells[1].Text, transdetail.Rows[0]["var_pisnewstb_boxtype"], "VC", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), "U", grdSTBDetails.Rows[i].Cells[5].Text); } } } if (str != "") { str = str.Substring(0, str.Length - 1); } String IPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (IPAddress == null) { IPAddress = Request.ServerVariables["REMOTE_ADDR"]; } string uploadResult = ""; DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); Random random = new Random(); string upload_id = Session["username"].ToString() + "_" + cur_time + "_" + random.Next(1000, 9999); if (Tbllist.Rows.Count > 0) { string directoryPath = string.Format(Server.MapPath("MyExcelFile/" + Session["username"].ToString())); try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } } catch (Exception ex) { // btnBeginTrans.Visible = false; return; } string file_name = "Warehousedata" + Session["username"].ToString() + "_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".txt"; string filepath = Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\" + file_name; ExportDataTabletoFile(Tbllist, "", true, filepath); Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); String DataSource = (String)helper.GetDatabaseDateSource(); String UserId = (String)helper.GetDatabaseUserId(); String Password = (String)helper.GetDatabasePassword(); string table_columns = "(num_inventval_transid,var_inventval_upload_id constant \"" + upload_id + "\",var_inventval_orderno,var_inventval_lcocode,var_inventval_deviceid,var_inventval_boxtype,var_inventval_type,var_inventval_model,var_inventval_manufacturer,var_inventval_company,var_inventval_city,var_inventval_state,num_inventval_scheameid,var_inventval_insby,VAR_INVENTVAL_STATUS,NUM_INVENTVAL_STBID,dat_inventval_insdate constant \"" + cur_timestamp + "\",var_inventval_apistatus,var_inventval_apismsg,dat_inventval_valdate,VAR_INVENTVAL_VALTYPE constant \"N\",VAR_INVENTVAL_TRANSTYPE constant \"" + Receipttype + "\",VAR_INVENTVAL_IP constant \"" + IPAddress + "\",VAR_INVENTVAL_REMARK constant \"" + txtRemark.Text.Trim() + "\")"; uploadResult = helper.cDataUpload(Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\" + file_name, Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\HathwayCTL.txt", Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\HathwayLOG.log", table_columns, DataSource, UserId, Password, "aoup_lcopre_pis_invent_raw", upload_id); } else { uploadResult = "0"; } if (uploadResult == "0") { string response = ""; if (Tbllist.Rows.Count > 0) { response = obj.UpdateInvIntStatus(Session["username"].ToString(), "L", transdetail.Rows[0]["transid"].ToString(), upload_id); } else { response = "9999"; } if (response == "9999") { Response.Redirect("FrmWarehouseBulkProcess.aspx?uniqueid=" + upload_id); } else { MessageAlert("Error While Updating", ""); return; } } else { if (uploadResult == "") { MessageAlert("Error While Uploading...", ""); return; } else { MessageAlert(uploadResult.ToString(), ""); return; } } }
protected void lnkbulk_click(object sender, EventArgs e) { if (FileUpload1.HasFile == true) { DateTime dd = DateTime.Now; string datetime = dd.Day + "" + dd.Month + "" + dd.Year + "" + dd.Hour + "" + dd.Minute + "" + dd.Second; String Path = Server.MapPath("~//ImageGarbage") + "\\" + datetime + Session["username"].ToString() + "_Warehouse"; if (FileUpload1.HasFile) { FileUpload1.SaveAs(Path + ".txt"); } string[] lines = System.IO.File.ReadAllLines(Path + ".txt"); if (lines.Length > grdSTBDetails.Rows.Count) { MessageAlert("Please upload valid file", ""); return; } DataTable transdetail = (DataTable)ViewState["transdetail"]; string Receipttype = ""; if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("SPSR")) { Receipttype = "SPSR"; } else if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("SPSN")) { Receipttype = "SPSN"; } else if (transdetail.Rows[0]["receiptno"].ToString().ToUpper().Contains("PPSN")) { Receipttype = "PPSN"; } else { Receipttype = "PPSR"; } DataTable Tbllist = new DataTable(); Tbllist.Columns.Add("transid"); Tbllist.Columns.Add("orderno"); Tbllist.Columns.Add("lcocode"); Tbllist.Columns.Add("deviceid"); Tbllist.Columns.Add("boxtype"); Tbllist.Columns.Add("type"); Tbllist.Columns.Add("model"); Tbllist.Columns.Add("manufacturer"); Tbllist.Columns.Add("company"); Tbllist.Columns.Add("city"); Tbllist.Columns.Add("state"); Tbllist.Columns.Add("scheameid"); Tbllist.Columns.Add("insby"); Tbllist.Columns.Add("Flag"); Tbllist.Columns.Add("STBID"); String str = ""; String Message = ""; try { foreach (var line in lines) { var STB = line.Split('\t')[0].Replace("'", ""); var type = line.Split('\t')[1]; var STBStatus = line.Split('\t')[2]; if (type == "STB" || type == "VC") { } else { Message = "Please provide Proper Type(STB or VC)"; str = ""; break; } if (STBStatus != "G" || STBStatus != "F" || STBStatus != "U") { } else { Message = "Please provide Proper Type(Good, Faulty or Undiliverd)"; str = ""; break; } DataTable tbl = (from DataRow dr in transdetail.Rows where dr["STB"].ToString() == STB select dr).CopyToDataTable(); string Stbid = tbl.Rows[0]["stbid"].ToString(); string Usertrans = tbl.Rows[0]["warehouse"].ToString(); str += Stbid; if (STBStatus == "G") { if (type == "STB") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Session["username"].ToString(), STB, transdetail.Rows[0]["var_pisnewstb_boxtype"], "STB", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), STBStatus, Stbid); } else if (type == "VC") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Session["username"].ToString(), STB, transdetail.Rows[0]["var_pisnewstb_boxtype"], "VC", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), STBStatus, Stbid); } } else { if (type == "STB") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Usertrans, STB, transdetail.Rows[0]["var_pisnewstb_boxtype"], "STB", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), STBStatus, Stbid); } else if (type == "VC") { Tbllist.Rows.Add(transdetail.Rows[0]["transid"], transdetail.Rows[0]["receiptno"], Usertrans, STB, transdetail.Rows[0]["var_pisnewstb_boxtype"], "VC", transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["makemodel"], transdetail.Rows[0]["company"], transdetail.Rows[0]["city"], transdetail.Rows[0]["state"], transdetail.Rows[0]["num_pisnewstb_schemeid"], Session["username"].ToString(), STBStatus, Stbid); } } } } catch (Exception ex) { MessageAlert("Error in Uploaded Data", ""); return; } if (str == "") { MessageAlert(Message, ""); return; } String IPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (IPAddress == null) { IPAddress = Request.ServerVariables["REMOTE_ADDR"]; } string uploadResult = ""; DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); Random random = new Random(); string upload_id = Session["username"].ToString() + "_" + cur_time + "_" + random.Next(1000, 9999); if (Tbllist.Rows.Count > 0) { string directoryPath = string.Format(Server.MapPath("MyExcelFile/" + Session["username"].ToString())); try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } } catch (Exception ex) { // btnBeginTrans.Visible = false; return; } string file_name = "Warehousedata" + Session["username"].ToString() + "_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".txt"; string filepath = Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\" + file_name; ExportDataTabletoFile(Tbllist, "", true, filepath); Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); String DataSource = (String)helper.GetDatabaseDateSource(); String UserId = (String)helper.GetDatabaseUserId(); String Password = (String)helper.GetDatabasePassword(); string table_columns = "(num_inventval_transid,var_inventval_upload_id constant \"" + upload_id + "\",var_inventval_orderno,var_inventval_lcocode,var_inventval_deviceid,var_inventval_boxtype,var_inventval_type,var_inventval_model,var_inventval_manufacturer,var_inventval_company,var_inventval_city,var_inventval_state,num_inventval_scheameid,var_inventval_insby,VAR_INVENTVAL_STATUS,NUM_INVENTVAL_STBID,dat_inventval_insdate constant \"" + cur_timestamp + "\",var_inventval_apistatus,var_inventval_apismsg,dat_inventval_valdate,VAR_INVENTVAL_VALTYPE constant \"N\",VAR_INVENTVAL_TRANSTYPE constant \"" + Receipttype + "\",VAR_INVENTVAL_IP constant \"" + IPAddress + "\",VAR_INVENTVAL_REMARK constant \"" + txtRemark.Text.Trim() + "\")"; uploadResult = helper.cDataUpload(Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\" + file_name, Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\HathwayCTL.txt", Server.MapPath("MyExcelFile/" + Session["username"].ToString()) + "\\HathwayLOG.log", table_columns, DataSource, UserId, Password, "aoup_lcopre_pis_invent_raw", upload_id); } else { uploadResult = "0"; } if (uploadResult == "0") { string response = ""; if (Tbllist.Rows.Count > 0) { response = obj.UpdateInvIntStatus(Session["username"].ToString(), "L", transdetail.Rows[0]["transid"].ToString(), upload_id); } else { response = "9999"; } if (response == "9999") { Response.Redirect("FrmWarehouseBulkProcess.aspx?uniqueid=" + upload_id); } else { MessageAlert("Error While Updating", ""); return; } } else { if (uploadResult == "") { MessageAlert("Error While Uploading...", ""); return; } else { MessageAlert(uploadResult.ToString(), ""); return; } } } else { MessageAlert("Please upload file", ""); return; } }
protected void btnUpload_Click(object sender, EventArgs e) { if (ddlpin.SelectedItem.ToString() == "-- Select Zip Code --") { msgbox("Please Select Zip Code"); return; } if (ddlstreet.SelectedItem.ToString() == "-- Select Street --") { msgbox("Please Select Street"); return; } if (ddllocation.SelectedItem.ToString() == "-- Select Location --") { msgbox("Please Select Location"); return; } string pincodecode = ""; string areacode = ""; string streetcode = ""; string locationcode = ""; string buildingcode = ""; string pincode = ""; string area = ""; string street = ""; string location = ""; string building = ""; pincodecode = ddlpin.SelectedValue.ToString(); areacode = ddlarea.SelectedValue.ToString(); streetcode = ddlstreet.SelectedValue.ToString(); locationcode = ddllocation.SelectedValue.ToString(); buildingcode = ddlbuilding.SelectedValue.ToString(); pincode = ddlpin.SelectedItem.ToString(); area = ddlarea.SelectedItem.ToString(); street = ddlstreet.SelectedItem.ToString(); location = ddllocation.SelectedItem.ToString(); building = ddlbuilding.SelectedItem.ToString(); //clearing lblStatusHeading.Text = ""; lblStatus.Text = ""; DataTable temp = new DataTable(); temp.Dispose(); string file_name = ""; if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } else { if (!SecurityValidation.SizeUploadValidation(fupData)) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Please upload file less than 5MB"; return; } } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory //string directoryPath = string.Format(@"D:/DataUpload/HathwayAutoRenewal/{0}", username.Trim()); //string filePath = directoryPath + "/" + fupData.PostedFile.FileName; //try //{ // if (!Directory.Exists(directoryPath)) // { // Directory.CreateDirectory(directoryPath); // } // fupData.SaveAs(filePath); //} string directoryPath = string.Format(@"D:/DataUpload/Hathway/{0}", username.Trim()); //string directoryPath = string.Format(@"E:/DataUpload/Hathway/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); Unique_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = Unique_id; string table_columns = "( VAR_CUST_STB, VAR_CUST_VC,VAR_CUST_APPLICANTTITLE,VAR_CUST_APPLICANTFIRSTNM,VAR_CUST_APPLICANTMEDDILNM,VAR_CUST_APPLICANTLASTNM,"; table_columns += " VAR_CUST_MOBILENO,VAR_CUST_LANDLINE,VAR_CUST_EMAIL,VAR_CUST_FLATNO,VAR_CUST_ADDRESS1,VAR_CUST_CITY,var_cust_planname,VAR_CUST_ZIPCODE constant \"" + pincodecode + "\",VAR_CUST_AREA constant \"" + area + "\","; table_columns += " VAR_CUST_AREACODE constant \"" + areacode + "\",VAR_CUST_STREET constant \"" + street + "\",VAR_CUST_LOCATION constant \"" + location + "\",VAR_CUST_BUILDING constant \"" + building + "\",VAR_CUST_UNIQUNO constant \"" + Unique_id + "\",VAR_CUST_LCOCODE constant \"" + username + "\",var_cust_state constant \"" + ViewState["State"] + "\")"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\Hathway\\" + username + "\\HathwayBulkEcafCTL.txt", "D:\\DataUpload\\Hathway\\" + username + "\\HathwayBulkEcafLOG.log", table_columns, "UPASSDB", "UPASS", "cba", "aoup_crf_cust_bulk_Raw", "" ); if (uploadResult == "0") { callprocedureTemp(); Response.Redirect("../Reports/frmMeddleBulkTransaction.aspx?uniqueid=" + Unique_id.Trim()); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadResult.ToString(); } } }
protected void btnUpload_Click(object sender, EventArgs e) { lblStatusHeading.Text = ""; lblStatus.Text = ""; DataTable temp = new DataTable(); temp.Dispose(); string file_name = ""; if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } else { if (!SecurityValidation.SizeUploadValidation(fupData)) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Please upload file less than 5MB"; return; } } // check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/HathwayBulk/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "( VAR_ACTDCT_ACCNO, VAR_ACTDCT_VCID, VAR_ACTDCT_REASON, VAR_ACTDCT_LCOCODE,var_actdct_action,VAR_ACTDCT_FILENAME constant \"" + file_name + "\",VAR_ACTDCT_FILEUNIQUEID constant \"" + upload_id + "\")"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayBulk\\" + username + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\HathwayBulk\\" + username + "\\HathwayBulkActDctCTL.txt", "D:\\DataUpload\\HathwayBulk\\" + username + "\\HathwayBulkActDctLOG.log", table_columns, "Upassdb", "UPASS", "cba", "aoup_lcopre_Bulk_act_dct_Raw", "" ); if (uploadResult == "0") { callprocedureTemp(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadResult.ToString(); } } }
protected void btnUpload_Click(object sender, EventArgs e) { //clearing lblStatusHeading.Text = ""; lblStatus.Text = ""; DataTable temp = new DataTable(); temp.Dispose(); string file_name = ""; if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/HathwayDiscount/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; string table_columns = "( var_lcopre_discount_accno, var_lcopre_discount_vcid, num_lcopre_discount_amt, dat_lcopre_discount_expirydt, var_lcopre_discount_requestby, var_lcopre_discount_reason,var_lcopre_discount_type)"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayDiscount\\" + username + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\HathwayDiscount\\" + username + "\\HathwayDiscountCTL.txt", "D:\\DataUpload\\HathwayDiscount\\" + username + "\\HathwayDiscountLOG.log", // "D:\\DataUpload\\HathwayDiscount\\HathwayDiscountCTL.txt", // "D:\\DataUpload\\HathwayDiscount\\HathwayDiscountLOG.log", table_columns, "upassdb", "upass", "cba", "aoup_lcopre_discount_raw", "" ); if (uploadResult == "0") { callprocedureTemp(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadResult.ToString(); } } }
protected void btnUpload_Click(object sender, EventArgs e) { //clearing lblStatusHeading.Text = ""; lblStatus.Text = ""; // btnBeginTrans.Visible = false; pnlErrData.Visible = false; if (ViewState["Bulk"].ToString() == "C") { change.Visible = true; } else { Operation.Visible = true; } // pnlSummary.Visible = false; DataTable temp = new DataTable(); rptErrData.DataSource = temp; rptErrData.DataBind(); temp.Dispose(); string file_name = ""; //check - file selected if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } else { if (!SecurityValidation.SizeUploadValidation(fupData)) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Please upload file less than 5MB"; return; } } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } //check - file length if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } if (Session["username"] != null) { username = ddlLco.SelectedValue;//Session["username"].ToString().Trim(); } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/Hathway/{0}", username.Trim()); //string directoryPath = string.Format(@"E:/DataUpload/Hathway/{0}", username.Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); // btnBeginTrans.Visible = false; return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "( var_lcopre_bulk_custid, var_lcopre_bulk_vcid, var_lcopre_bulk_lcocode, var_lcopre_bulk_planname, var_lcopre_bulk_action, var_lcopre_bulk_ecs_flag ,var_lcopre_bulk_insby constant \"" + username + "\", var_lcopre_bulk_useruniqueid constant \"" + upload_id + "\", dat_lcopre_bulk_date constant \"" + cur_timestamp + "\", var_lcopre_bulk_file constant \"" + file_name + "\",var_two_step_proc_flag constant \"" + "Y" + "\",var_lcopre_bulk_new_planname,var_lcopre_bulk_foc_1,var_lcopre_bulk_foc_2,var_lcopre_bulk_foc_3)"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\Hathway\\" + username + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\Hathway\\" + username + "\\HathwayCTL.txt", "D:\\DataUpload\\Hathway\\" + username + "\\HathwayLOG.log", table_columns, "upassdb", "upass", "cba", "aoup_lcopre_bulk_upload_raw", upload_id); if (uploadResult == "0") { Response.Redirect("../Reports/frmMiddlePageBulkTransaction.aspx?uniqueid=" + upload_id); // callprocedure(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; } else { lblStatus.Text = uploadResult.ToString(); } } }
protected void btnUpload_Click(object sender, EventArgs e) { if (rblMode.SelectedValue == "0") { if (txtAccountNo.Text.Length > 0) { string valid = SecurityValidation.chkData("N", txtAccountNo.Text); if (valid == "") { String IPAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"]; if (IPAddress == null) { IPAddress = Request.ServerVariables["REMOTE_ADDR"]; } string IPAdd = Convert.ToString(IPAddress); Cls_Business_UserAccountMap obj = new Cls_Business_UserAccountMap(); string pro_output = obj.UserAccountMap(Session["username"].ToString().Trim(), IPAdd, ddlLco.SelectedValue, txtAccountNo.Text, rblAction.SelectedValue.ToString(), "S"); if (pro_output.Split('#')[0] == "9999") { lblStatusHeading.Text = "Successful"; lblStatus.Text = ""; } else { lblStatusHeading.Text = pro_output.Split('#')[1].ToString();// "File Upload : Failed"; } txtAccountNo.Text = ""; ddlLco.SelectedIndex = 0; rblAction.SelectedValue = "Y"; } else { lblStatusHeading.Text = valid.ToString(); return; } } } else { lblStatusHeading.Text = ""; lblStatus.Text = ""; DataTable temp = new DataTable(); temp.Dispose(); string file_name = ""; if (!fupData.HasFile) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Select non-empty tab deliminated file first and try again"; return; } //check - file extension if (fupData.PostedFile.ContentType != "text/plain") { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Only tab deliminated text(.txt) files are allowed"; return; } else { if (!SecurityValidation.SizeUploadValidation(fupData)) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "Please upload file less than 5MB"; return; } } if (fupData.PostedFile.ContentLength == 0) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = "File does not have contents"; return; } //check - directory and save file in diectory string directoryPath = string.Format(@"D:/DataUpload/HathwayBulk/{0}", Session["username"].ToString().Trim()); string filePath = directoryPath + "/" + fupData.PostedFile.FileName; try { if (!Directory.Exists(directoryPath)) { Directory.CreateDirectory(directoryPath); } fupData.SaveAs(filePath); } catch (Exception ex) { lblStatusHeading.Text = "File Upload : Failed"; lblStatus.Text = ex.Message.ToString(); return; } Cls_Presentation_Helper helper = new Cls_Presentation_Helper(); DateTime date = DateTime.Now; string cur_timestamp = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); string cur_time = DateTime.Now.ToString("dd-MMM-yyyy_hh:mm:ss"); file_name = fupData.PostedFile.FileName; Random random = new Random(); upload_id = username + "_" + cur_time + "_" + random.Next(1000, 9999); ViewState["upload_id"] = upload_id; string table_columns = "( var_user_acc_username, var_user_acc_accountno, Var_user_acc_activeflag)"; string uploadResult = helper.cDataUpload("D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\" + fupData.PostedFile.FileName, "D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\HathwayUserAccMappingCTL.txt", "D:\\DataUpload\\HathwayBulk\\" + Session["username"].ToString().Trim() + "\\HathwayUserAccMappingLOG.log", table_columns, "Upassdb", "UPASS", "cba", "AOUP_LCOPRE_USER_ACC_MAP_raw", "" ); if (uploadResult == "0") { callprocedureTemp(); } else { if (uploadResult == "") { lblStatus.Text = "Error While Uploading..."; lblStatus.Visible = true; } else { lblStatus.Text = uploadResult.ToString(); lblStatus.Visible = true; } } } }