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;
}
}
}
}
