protected void lb_SalesOrder_Released_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
// Released Sales Order By Code unit function
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.ReleaseSalesOrder(Convert.ToString(ViewState["SalesOrder"]));
objser1 = null;
var message = new JavaScriptSerializer().Serialize("Sales Order No: " + Convert.ToString(ViewState["SalesOrder"]) + " has been released successfully.");
var script = string.Format("alert({0});window.location='DashBoard.aspx';", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current);
NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current);
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
no = objser.CreateReleasedProductionOrder(drpItem.SelectedItem.Value, Convert.ToString(Session["NavUserName"]));
objser = null;
lblItemNo.Text = drpItem.SelectedItem.Value;
lblItemDescription.Text = drpItem.SelectedItem.Text;
lblItemNo.Visible = false;
lblNo.Text = no;
pnlHide.Visible = false;
pnlShow.Visible = true;
tblID.Visible = true;
txtPostingDate.Focus();
}
catch (Exception ex)
{
var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
}
public void ViewedOrder()
{
try
{
if (Request["OrderNo"].ToString() != "" && Request["OrderNo"].ToString() != null)
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; // "JCIL\\ADMINISTRATOR"; //"MSPL\\NAVTRN1"; //
NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; //"JCILADMIN@123"; //"admin@12"; //
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
objser.OrderViewed(Request["OrderNo"]);
}
else
{
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
public void ShowShipmentCount()
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
//string str;
//str = Convert.ToInt32(objser.CountAgentsOutward(SessionManager.GetAgentCode(HttpContext.Current), Convert.ToInt32(ConfigurationManager.AppSettings["Agenttype"]))).ToString();
//if (str != null && str != "" && str != "0")
//{
// lblShipmentNotification.Text = "( " + Convert.ToInt32(objser.CountAgentsOutward(SessionManager.GetAgentCode(HttpContext.Current), Convert.ToInt32(ConfigurationManager.AppSettings["Agenttype"]))).ToString() + " )*";
//}
//else
//{
// lblShipmentNotification.Text = "";
//}
//objser = null;
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});window.location='DashBoard.aspx';", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
//Response.Redirect("ThanksYouForSub.html");
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (Request["OrderNo"].ToString() != "")
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
string str = ConfigurationManager.AppSettings["FilePath"] + objser.OrderConfirmationPrint(Convert.ToString(Request["OrderNo"].ToString()));
Response.Clear();
Response.ContentType = "application/pdf";
Response.WriteFile(str);
Response.Flush();
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
tblDate.Visible = true;
tblMessage.Visible = false;
if (!Page.IsPostBack)
{
if (Session["userName"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
txtMail.Text = objser.GetAgentEmailAddr(SessionManager.GetAgentCode(HttpContext.Current));
}
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
//send for pdf
protected void btnmail_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (Request["CustomerNo"].ToString() != "")
{
if (txtStartDate.Text != null && txtEndDate.Text != null && txtEndDate.Text != "" && txtEndDate.Text != "" && txtMail.Text != "")
{
DateTime startdate = Convert.ToDateTime(txtStartDate.Text);
DateTime enddate = Convert.ToDateTime(txtEndDate.Text);
DateTime todayDate = DateTime.Now;
if (IsValidEmailId(txtMail.Text))
{
if (enddate < startdate)
{
var message = new JavaScriptSerializer().Serialize("End Date should not be less than Start Date.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
else
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
objser.SendMailforCustomerLedger(Convert.ToString(Request["CustomerNo"]), txtMail.Text, txtMail1.Text, startdate, enddate, Convert.ToBoolean(0));
txtEndDate.Text = "";
txtStartDate.Text = "";
txtMail.Text = "";
txtMail1.Text = "";
tblMessage.Visible = true;
tblDate.Visible = false;
}
}
else
{
Label1.Text = "Please enter Start date,End Date and Email.";
Label1.Visible = true;
}
}
else
{
Label1.Text = "Please enter Start date,End Date and Email.";
Label1.Visible = true;
}
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
public static string LoginCredential(string Username, string Password)
{
try
{
string Success = "Success";
string SuccessApp = "SuccessApp";
string Fail = "Fail";
Agent obj = Agent.LoginCredentials(Username, Password);
if (obj != null)
{
HttpContext.Current.Session["userName"] = Username;
SessionManager.AddToUserSession(HttpContext.Current, obj.Code, obj.AgentName);
SessionManager.AddItemCategoryToSession(HttpContext.Current, obj.ItemCategoryCode);
SessionManager.AddUserTypeSession(HttpContext.Current, obj.UserType);
//SessionManager.AddLoginTimeSession(HttpContext.Current, Convert.ToDateTime(obj.LastLoginTime));
HttpContext.Current.Session["ItemCategoryCode"] = obj.ItemCategoryCode;
// for updating the date time of the user login. .// added by Raj Shah 09/11/2016
try
{
NetworkCredential NetCredentials = new NetworkCredential(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"]);
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
//DateTime LastLoginTime = objser1.GetLastLoginDateTime(obj.LastLoginTime);
SessionManager.AddLoginTimeSession(HttpContext.Current, Convert.ToDateTime(obj.LastLoginTime));
objser1.LastLoginLogoutDateTime(obj.Code, DateTime.Now, true);
objser1 = null;
}
catch (Exception ex)
{
// not to throw error.
}
if (obj.AccountActivated == false)
{
return(SuccessApp);
}
else
{
return(Success);
}
}
else
{
return(Fail);
}
}
catch (Exception ex)
{
//throw ex;
return(ex.Message);
}
}
protected void btnExcel_Download_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (txtStartDate.Text != null && txtEndDate.Text != null && txtEndDate.Text != "" && txtEndDate.Text != "")
{
DateTime startdate = Convert.ToDateTime(txtStartDate.Text);
DateTime enddate = Convert.ToDateTime(txtEndDate.Text);
DateTime todayDate = DateTime.Now;
if (enddate < startdate)
{
var message = new JavaScriptSerializer().Serialize("End Date should not be less than Start Date.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
else
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
string str = ConfigurationManager.AppSettings["FilePath"] + objser.CustomerLedgerPrint(Convert.ToString(Request["CustomerNo"]), Convert.ToDateTime(startdate), Convert.ToDateTime(enddate), Convert.ToBoolean(1));
hf_Excel.Value = str;
ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: AddPathExcel(); ", true);
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AppendHeader("content-disposition", "attachment; filename=\"" + str + "\"");
Response.WriteFile(str);
Response.Flush();
Response.End();
Response.Close();
}
}
else
{
lblMessage.Text = "Please enter Start date and End Date both.";
lblMessage.Visible = true;
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
public void StatisticData()
{
try
{
// Called SalesOrderStatistic function Codeunit Function.
SalesOrderStatistics so = new SalesOrderStatistics();
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.SalesOrderStatistics(Convert.ToString(Request.QueryString["SalesOrder"]));
objser1 = null;
// Filter with Sales Order No and Fetched Statistic Data
SalesOrderStatistics_Service objso = new SalesOrderStatistics_Service();
objso.UseDefaultCredentials = true;
objso.Credentials = NetCredentials;
List <SalesOrderStatistics_Filter> filterArray = new List <SalesOrderStatistics_Filter>();
SalesOrderStatistics_Filter Filter = new SalesOrderStatistics_Filter();
Filter.Field = SalesOrderStatistics_Fields.No;
Filter.Criteria = Convert.ToString(Request.QueryString["SalesOrder"]);
filterArray.Add(Filter);
SalesOrderStatistics[] ListData = objso.ReadMultiple(filterArray.ToArray(), null, 1);
if (ListData.Length > 0)
{
lbl_Amt_Excl_VAT.Text = (ListData[0].TotalSalesLine1_Line_Amount).ToString("0.00");
lbl_Total_Excl_VAT.Text = (ListData[0].TotalAmount11).ToString("0.00");
lbl_Charges_Amt.Text = (ListData[0].TotalSalesLine1_Charges_To_Customer).ToString("0.00");
lbl_Tax_Amt.Text = (ListData[0].TotalSalesLine1_Tax_Amount).ToString("0.00");
lbl_Net_total.Text = (ListData[0].TotalSalesLine1_Amount_To_Customer).ToString("0.00");
lbl_Excise_Amt.Text = (ListData[0].TotalSalesLine1_Excise_Amount).ToString("0.00");
}
objso = null;
so = null;
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void Bnt_SendMail_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (txt_UserId.Text != null && txt_EmailId.Text != null && txt_UserId.Text != "" && txt_EmailId.Text != "")
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
Boolean bol = objser.SendVerificationCode(txt_UserId.Text, txt_EmailId.Text);
if (bol == true)
{
Response.Write("<script language='javascript'>window.alert('Verification code has been sent successfully in your mail.');</script>");
ShowSection2();
}
else
{
Response.Write("<script language='javascript'>window.alert('Please enter valid User Id and E-mail Id.');</script>");
txt_UserId.Text = string.Empty;
txt_EmailId.Text = string.Empty;
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Please enter User Id and E-mail Id.');</script>");
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current);
NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current);
ItemTrackDetails.DataSource = getTrackList();
ItemTrackDetails.DataBind();
foreach (RepeaterItem itemEquipment in ItemTrackDetails.Items)
{
string lblLotNo = (itemEquipment.FindControl("lblLotNo") as Label).Text;
string Qty = (itemEquipment.FindControl("lblQty") as Label).Text;
string lblDimenItem = (itemEquipment.FindControl("lblDimenItem") as Label).Text;
Decimal quantity = 0;
if (Qty != null && Qty != "")
{
if (Qty != null)
{
quantity = Convert.ToDecimal(Qty);
}
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
objser.CreateItemJournal(1, Request.QueryString["No"], Convert.ToDecimal(Qty), string.Empty, lblDimenItem, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), lblLotNo);
objser = null;
}
}
}
catch (Exception ex)
{
var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
}
protected void Btn_Submit_Click(object sender, EventArgs e)
{
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
if (txt_VerifyCode.Text != null && txt_ConfirmPwd.Text != null && txtRe_ConfirmPwd.Text != null)
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
Boolean bol1 = objser.IsVarified(txt_UserId1.Text, txt_VerifyCode.Text, txt_ConfirmPwd.Text);
if (bol1 == true)
{
Response.Write("<script language='javascript'>window.alert('Password has been changed successfully.');window.location='LogIn.aspx';</script>");
ClearData();
}
else
{
Response.Write("<script language='javascript'>window.alert('Please check your verification code.');</script>");
}
}
else
{
Response.Write("<script language='javascript'>window.alert('Please enter Verification Code, Confirm-Password and Reconfirm-Password.');</script>");
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});window.location='DashBoard.aspx';", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void lb_Modify_Click(object sender, EventArgs e)
{
Boolean flag = false;
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
try
{
foreach (RepeaterItem item in rpt_Cart.Items)
{
HiddenField hf_ProductCode = (HiddenField)item.FindControl("hf_ProductCode");
TextBox tb_ProductName = (TextBox)item.FindControl("tb_ProductName");
HiddenField dd_UOM = (HiddenField)item.FindControl("hf_UOM");
TextBox tb_Qty = (TextBox)item.FindControl("tb_Qty");
TextBox tb_Price = (TextBox)item.FindControl("tb_Price");
TextBox tb_CPrice = (TextBox)item.FindControl("txt_Customerprice");
DropDownList dd_Variant = (DropDownList)item.FindControl("dd_Variant");
TextBox tb_Remark = (TextBox)item.FindControl("tb_Remark");
TextBox tb_Discount = (TextBox)item.FindControl("tb_Discount");
TextBox tb_Total = (TextBox)item.FindControl("tb_Total");
HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped");
HiddenField hf_OutStandingQty = (HiddenField)item.FindControl("hf_OutStandingQty");
HiddenField hf_CustomerPriceGroup = (HiddenField)item.FindControl("hf_CustomerPriceGroup") as HiddenField;
if (Convert.ToDecimal(hf_QuantityShipped.Value) > 0)
{
if (tb_Qty.Text != string.Empty)
{
string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value));
decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty);
if (mod > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true);
flag = false;
tb_Qty.Focus();
tb_Qty.Text = string.Empty;
break;
}
else
{
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
objser.UpdateBanketSalesLineQty(Convert.ToString(Request["BlanketOrderNo"]), Convert.ToInt32(Request["LineNo"]), Convert.ToDecimal(tb_Qty.Text));
objser = null;
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.UpdateSalesLineQty(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), Convert.ToDecimal(tb_Qty.Text));
objser1 = null;
flag = true;
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity.');", true);
flag = false;
tb_Qty.Focus();
break;
}
}
else
{
decimal amt = Convert.ToDecimal(Convert.ToDecimal(tb_Qty.Text) * Convert.ToDecimal(tb_CPrice.Text));
decimal totalamount = Convert.ToDecimal(amt);
if (tb_Qty.Text != null && tb_CPrice.Text != null)
{
if (Convert.ToDecimal(tb_CPrice.Text) < Convert.ToDecimal(tb_Price.Text))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter price above base price.');", true);
flag = false;
tb_CPrice.Focus();
tb_CPrice.Text = string.Empty;
break;
}
else
{
string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value));
decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty);
if (mod > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true);
flag = false;
tb_Qty.Focus();
tb_Qty.Text = string.Empty;
break;
}
else
{
decimal d = Convert.ToDecimal(tb_Price.Text) * 15 / 100;
d = Convert.ToDecimal(tb_Price.Text) + d;
if (Convert.ToDecimal(tb_CPrice.Text) >= d)
{
ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: fnShowMessage(); ", true);
flag = false;
tb_CPrice.Focus();
tb_CPrice.Text = string.Empty;
break;
}
else
{
flag = true;
//Update Blanket Order due to updating Qty in blanket Order as well as Sales Order
Web_Order_Mail objser2 = new Web_Order_Mail();
objser2.UseDefaultCredentials = true;
objser2.Credentials = NetCredentials;
objser2.UpdateSalesLine(Convert.ToString(Request["BlanketOrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(tb_CPrice.Text), tb_Remark.Text);
objser2 = null;
// Update SalesOrder Lines Details.
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.UpdateSalesLine(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(tb_CPrice.Text), tb_Remark.Text);
objser1 = null;
}
}
}
}
else
{
var message = new JavaScriptSerializer().Serialize("Quantity or Bill Price should not be blank or zero.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
if (flag == false)
{
}
else
{
//ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Record updated successfully.');window.location ='OrderModificationView.aspx';", true);
Response.Redirect("OrderModificationView.aspx?OrderNo=" + Request["OrderNo"].ToString() + "&BlanketOrderNo=" + Convert.ToString(Request["BlanketOrderNo"]) + "&PostingDate=" + Convert.ToString(Request.QueryString["PostingDate"]), false);
}
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void lb_Finish_Click(object sender, EventArgs e)
{
CheckBox chk = sender as CheckBox;
RepeaterItem ri = chk.NamingContainer as RepeaterItem;
if (ri != null)
{
Label tb_Qty1 = ri.FindControl("tdAmt") as Label;
TextBox txtPrice = ri.FindControl("txtAmounttoVerify") as TextBox;
CheckBox chk1 = ri.FindControl("chk_Select") as CheckBox;
if (chk1.Checked == true)
{
}
}
try
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; // "JCIL\\ADMINISTRATOR"; //"MSPL\\NAVTRN1"; //
NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; //"JCILADMIN@123"; //"admin@12"; //
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
string bankname = string.Empty;
string bankbranch = string.Empty;
string modeofpayment = string.Empty;
decimal amount = 0;
string accountno = string.Empty;
string customerno = Convert.ToString(Request["Customer"]);
DateTime d = Convert.ToDateTime(txtDate.Text);
if (tb_BankName.Text != "" && tb_BankName.Text != string.Empty)
{
bankname = tb_BankName.Text;
}
if (txt_BankBranch.Text != "" && txt_BankBranch.Text != string.Empty)
{
bankbranch = txt_BankBranch.Text;
}
if (drpModeofPayment.SelectedItem.Text != "")
{
modeofpayment = drpModeofPayment.SelectedItem.Text;
}
if (txt_PaymentAmount.Text != "" && txt_PaymentAmount.Text != string.Empty)
{
amount = Convert.ToDecimal(txt_PaymentAmount.Text);
}
if (txtAccountNo.Text != "" && txtAccountNo.Text != string.Empty)
{
accountno = txtAccountNo.Text;
}
if (txtDate.Text != "" && txtDate.Text != string.Empty)
{
d = Convert.ToDateTime(txtDate.Text);
}
//string strdata = objser1.SendRTGSForm(bankname, bankbranch, modeofpayment, amount, accountno, customerno, d, Convert.ToString(rnd.Next(1, 10000)));
objser1 = null;
}
catch (Exception ex)
{
throw ex;
}
}
//private void BindTextGroupCode(string TextGroupCode, DropDownList dd_TextGroupCode)
//{
// try
// {
// List<ProductCat> list = ProductCat.ListTextGroupCode();
// if (list != null && list.Count > 0)
// {
// dd_TextGroupCode.DataSource = list;
// dd_TextGroupCode.DataTextField = "Code";
// dd_TextGroupCode.DataValueField = "Code";
// dd_TextGroupCode.DataBind();
// dd_TextGroupCode.Items.Insert(0, new ListItem("-Select-", "0"));
// }
// else
// {
// dd_TextGroupCode.DataSource = null;
// dd_TextGroupCode.DataBind();
// }
// }
// catch (Exception ex)
// {
// l_Error.Text = ex.Message;
// l_Error.Visible = true;
// }
//}
public void btn_Update(object sender, EventArgs e)
{
try
{
Boolean flag = false;
if (drpNoseries.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select sales order no series.');", true);
}
else if (drpStructure.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select structure.');", true);
}
else if (drpProductCode.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Product code.');", true);
}
else if (txtDestination.Text == "")
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter Destination.');", true);
}
else if (drplocationcode.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Location code.');", true);
}
else
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
foreach (RepeaterItem item in rpt_FinalCart.Items)
{
HiddenField ItemNo = (HiddenField)item.FindControl("hf_ItemNo");
HiddenField LineNo = (HiddenField)item.FindControl("hf_LineNo");
TextBox Qty_to_Ship = (TextBox)item.FindControl("Qty_to_Ship");
TextBox tb_Discount = (TextBox)item.FindControl("tb_discount");
Label lbl_QTY = (Label)item.FindControl("lbl_QTY");
DropDownList dd_TaxAreaCode = (DropDownList)item.FindControl("dd_TaxAreaCode");
TextBox dd_TaxGroupCode = (TextBox)item.FindControl("dd_TaxGroupCode");
DropDownList dd_Excise_PostingGrpCode = (DropDownList)item.FindControl("dd_Excise_PostingGrpCode");
Label lbl_SalesOrderNo = (Label)item.FindControl("lbl_SalesOrderNo");
Label lbl_home_logo = (Label)item.FindControl("lbl_home_logo");
if (Qty_to_Ship.Text == "")
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be allowed blank.');", true);
flag = true;
}
else if (Convert.ToDecimal(Qty_to_Ship.Text) == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be allowed zero.');", true);
Qty_to_Ship.Focus();
flag = true;
}
else if (Convert.ToDecimal(Qty_to_Ship.Text) > Convert.ToDecimal(lbl_QTY.Text))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be greater than Order Quantity.');", true);
Qty_to_Ship.Focus();
flag = true;
}
else if (Convert.ToString(tb_Discount.Text) == "")
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Discount should not be allowed blank.');", true);
tb_Discount.Focus();
tb_Discount.Text = Convert.ToString(0);
flag = true;
}
//else if (dd_TaxGroupCode.SelectedIndex == 0)
//{
// ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Tax Group Code.');", true);
// flag = true;
//}
else if (dd_Excise_PostingGrpCode.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Excise Group Code.');", true);
flag = true;
}
else
{
string str = string.Empty;
if (drpFormCode.SelectedIndex == 0)
{
str = "";
}
else
{
str = Convert.ToString(drpFormCode.SelectedValue);
}
// Update Values of Blanket Sales Order by Codeunit Function.
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.UpdateBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"]), string.Empty, drpProductCode.SelectedItem.Value, drpStructure.SelectedItem.Value, txtTransporterName.Text, drpNoseries.SelectedItem.Value, txtDestination.Text, Convert.ToString(str), drplocationcode.SelectedValue);
objser1 = null;
// Update Quantity to ship in Sales Order by Codeunit Function.
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
objser.UpdateQtyToShip(Convert.ToString(Request.QueryString["OrderNo"]), Convert.ToInt32(LineNo.Value), Convert.ToDecimal(Qty_to_Ship.Text), Convert.ToDecimal(tb_Discount.Text), string.Empty, Convert.ToString(dd_TaxGroupCode.Text), Convert.ToString(dd_Excise_PostingGrpCode.SelectedItem.Value));
objser = null;
}
}
if (flag == true)
{
}
else
{
// Release Blanket Sales Order by Codeunit Function.
Web_Order_Mail objservice = new Web_Order_Mail();
objservice.UseDefaultCredentials = true;
objservice.Credentials = NetCredentials;
objservice.ReleaseBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"]));
objservice = null;
// Make Order By Codeunit Function Return with OrderNo.
Web_Order_Mail objser2 = new Web_Order_Mail();
objser2.UseDefaultCredentials = true;
objser2.Credentials = NetCredentials;
string MakeOrderNo = objser2.MakeOrder(4, Convert.ToString(Request.QueryString["OrderNo"]));
objser2 = null;
//lb_Update.Visible = false;
//lb_Satistic.Visible = true;
//lbl_home_logo.Visible = false;
lb_Update.Visible = false;
lb_Satistic.Visible = true;
// lbl_home_logo.Visible = false;
lbl_SalesOrderNo.Visible = true;
lblOrderNo.Visible = false;
blanketOrder_tr.Visible = true;
lbl_blk_No.Text = Convert.ToString(Request.QueryString["OrderNo"]);
ViewState["SalesOrder"] = Convert.ToString(MakeOrderNo);
lbl_SalesOrderNo.Text = Convert.ToString(MakeOrderNo);
var message = new JavaScriptSerializer().Serialize("Order has been successfully updated and Sales Order generated - Sales Order No. " + MakeOrderNo.ToString() + "");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
}
catch (Exception ex)
{
string IsSalesOrderExist = string.Empty;
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objservice = new Web_Order_Mail();
objservice.UseDefaultCredentials = true;
objservice.Credentials = NetCredentials;
IsSalesOrderExist = objservice.IsOrderExistfromBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"]));
if (IsSalesOrderExist != "")
{
lb_Update.Visible = false;
lb_Satistic.Visible = true;
ViewState["SalesOrder"] = Convert.ToString(IsSalesOrderExist);
objservice.ReleaseBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"]));
objservice = null;
var message = new JavaScriptSerializer().Serialize("Order has been successfully updated and Sales Order generated - Sales Order No. " + IsSalesOrderExist.ToString() + "");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
else
{
objservice.ReOpenOrder(Convert.ToString(Request.QueryString["OrderNo"]));
objservice = null;
lb_Update.Visible = true;
lb_Satistic.Visible = false;
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
//var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
//var script = string.Format("alert({0});", message);
//ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void lb_Modify_Click(object sender, EventArgs e)
{
Boolean flag = false;
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
try
{
foreach (RepeaterItem item in rpt_Cart.Items)
{
HiddenField hf_ProductCode = (HiddenField)item.FindControl("hf_ProductCode");
TextBox tb_ProductName = (TextBox)item.FindControl("tb_ProductName");
HiddenField dd_UOM = (HiddenField)item.FindControl("hf_UOM");
TextBox tb_Qty = (TextBox)item.FindControl("tb_Qty");
TextBox txtSellingPrice = (TextBox)item.FindControl("txtSellingPrice");
DropDownList dd_Variant = (DropDownList)item.FindControl("dd_Variant");
TextBox tb_Remark = (TextBox)item.FindControl("tb_Remark");
HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped");
HiddenField hf_OutStandingQty = (HiddenField)item.FindControl("hf_OutStandingQty");
HiddenField CustomerId = (HiddenField)item.FindControl("hf_SelltoCustomerNo") as HiddenField;
HiddenField ConsigneeId = (HiddenField)item.FindControl("hf_ShiptoCode") as HiddenField;
HiddenField hf_CustomerPriceGroup = (HiddenField)item.FindControl("hf_CustomerPriceGroup") as HiddenField;
if (string.IsNullOrEmpty(ConsigneeId.Value))
{
ConsigneeId.Value = CustomerId.Value;
}
string s = Convert.ToString(PriceforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value, CustomerId.Value, ConsigneeId.Value));
decimal amt = Convert.ToDecimal(Convert.ToDecimal(tb_Qty.Text) * Convert.ToDecimal(txtSellingPrice.Text));
decimal totalamount = Convert.ToDecimal(amt);
string ConsumerPrice = Convert.ToString(ConsumerPriceforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text));
decimal ConsPriceIncPercentage = 0;
ConsPriceIncPercentage = Convert.ToDecimal(ConsumerPrice) + (Convert.ToDecimal(ConsumerPrice) * Convert.ToDecimal(ConfigurationManager.AppSettings["ConsumerPriceIncreasePercentage"]) / 100);
if (tb_Qty.Text != null && txtSellingPrice.Text != null)
{
if (Convert.ToDecimal(ConsPriceIncPercentage) > 0)
{
if (Convert.ToDecimal(txtSellingPrice.Text) > Convert.ToDecimal(ConsPriceIncPercentage))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Bill Price exceeds permissible limit.');", true);
txtSellingPrice.Focus();
var script = String.Format("document.getElementById('{0}').select();", txtSellingPrice.ClientID);
ClientScript.RegisterStartupScript(GetType(), "focus", script, true);
}
else if (Convert.ToDecimal(txtSellingPrice.Text) < Convert.ToDecimal(s))
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Bill Price below permissible limit.');", true);
txtSellingPrice.Focus();
var script = String.Format("document.getElementById('{0}').select();", txtSellingPrice.ClientID);
ClientScript.RegisterStartupScript(GetType(), "focus", script, true);
}
else
{
string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text));
decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty);
if (mod > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true);
flag = false;
tb_Qty.Focus();
tb_Qty.Text = string.Empty;
break;
}
else
{
flag = true;
//Update Blanket Order due to updating Qty in blanket Order as well as Sales Order
Web_Order_Mail objser2 = new Web_Order_Mail();
objser2.UseDefaultCredentials = true;
objser2.Credentials = NetCredentials;
objser2.UpdateSalesLine(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(txtSellingPrice.Text), tb_Remark.Text);
objser2 = null;
}
}
}
}
if (flag == false)
{
}
else
{
Response.Redirect("BlanketOrderModificationView.aspx?OrderNo=" + Request["OrderNo"].ToString() + "&BlanketOrderNo=" + Convert.ToString(Request["BlanketOrderNo"]) + "&PostingDate=" + Convert.ToString(Request.QueryString["PostingDate"]), false);
}
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ViewState["Indicator"] != null)
{
indicatorofOutputPosted = true;
}
if (!Regex.IsMatch(txtPostingDate.Text, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$") || !Regex.IsMatch(txtDocumentDate.Text, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$"))
{
var message1 = new JavaScriptSerializer().Serialize("Not Valid dates!!!");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
else
{
foreach (GridViewRow g1 in gvOutput.Rows)
{
string Qty = (g1.FindControl("txtOut") as TextBox).Text;
if (Qty != null && Qty != "")
{
OpSum = OpSum + Convert.ToDecimal(Qty);
}
lblOutputSum.Text = ":" + Convert.ToString(OpSum);
}
foreach (GridViewRow g1 in gvCons.Rows)
{
string Qty = (g1.FindControl("txtCons") as TextBox).Text;
if (Qty != null && Qty != "")
{
ConsSum = ConsSum + Convert.ToDecimal(Qty);
}
lblConsumptionTotal.Text = ":" + Convert.ToString(ConsSum);
}
if (OpSum == ConsSum)
{
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current);
NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current);
try
{
if (indicatorofOutputPosted == false)
{
foreach (GridViewRow g1 in gvOutput.Rows)
{
string code = (g1.FindControl("lblDimCode1") as Label).Text;
string Qty = (g1.FindControl("txtOut") as TextBox).Text;
Decimal quantity = 0;
if (Qty != null && Qty != "")
{
if (Qty != null)
{
quantity = Convert.ToDecimal(Qty);
}
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
// 0 = output
objser.CreateItemJournal(0, lblNo.Text, quantity, code, lblItemNo.Text, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), string.Empty);
objser = null;
}
}
// posted the entry for output
Web_Order_Mail objserv = new Web_Order_Mail();
objserv.UseDefaultCredentials = true;
objserv.Credentials = NetCredentials;
indicatorofOutputPosted = objserv.PostItemJournal(0);
objserv = null;
}
try
{
foreach (GridViewRow g1 in gvCons.Rows)
{
string code = (g1.FindControl("lblDimCode2") as Label).Text;
string Qty = (g1.FindControl("txtCons") as TextBox).Text;
if (Qty != null && Qty != "")
{
Decimal quantity = Convert.ToDecimal(Qty);
Web_Order_Mail objser = new Web_Order_Mail();
objser.UseDefaultCredentials = true;
objser.Credentials = NetCredentials;
// 1 = Consumption
objser.CreateItemJournal(1, lblNo.Text, quantity, code, lblItemNo.Text, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), string.Empty);
objser = null;
}
}
// Consumption post
Web_Order_Mail objservc = new Web_Order_Mail();
objservc.UseDefaultCredentials = true;
objservc.Credentials = NetCredentials;
bool i = objservc.PostItemJournal(1);
objservc = null;
}
catch (Exception ex)
{
ViewState["Indicator"] = true;
var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
var messagefordi1 = new JavaScriptSerializer().Serialize("Production Order :" + lblNo.Text + " : Output and Consumption entries are posted successfully.!!!");
var scriptForview = string.Format("alert({0});window.location='ShowRlsProductOdr.aspx';", messagefordi1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", scriptForview, true);
}
catch (Exception ex)
{
//ViewState["Indicator"] = true;
var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
}
else
{
var message1 = new JavaScriptSerializer().Serialize("Sum of Output and Consumption must be same!!!");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
}
}
protected void btn_Submit_Click(object sender, EventArgs e)
{
try
{ //Deleting Blank Lines of Gridview
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
Boolean flag = true;
for (int i = dtCurrentTable.Rows.Count - 1; i >= 0; i--)
{
if (dtCurrentTable.Rows[i]["CustomerName"].ToString() == string.Empty && dtCurrentTable.Rows[i]["Location"].ToString() == string.Empty && dtCurrentTable.Rows[i]["ItemList"].ToString() == Convert.ToString(0))
{
dtCurrentTable.Rows[i].Delete();
}
else if (dtCurrentTable.Rows[i]["CustomerName"].ToString() == string.Empty && dtCurrentTable.Rows[i]["ItemList"].ToString() == Convert.ToString(0))
{
dtCurrentTable.Rows[i].Delete();
}
}
dtCurrentTable.AcceptChanges();
DataTable dt = dtCurrentTable;
//Deleting Blank Lines of Gridview
//Checked validations of Gridview fields
for (int i = 0; i < dtCurrentTable.Rows.Count; i++)
{
TextBox lb_CustomerName = (TextBox)Gridview3.Rows[i].Cells[1].FindControl("lb_CustomerName");
TextBox lb_Location = (TextBox)Gridview3.Rows[i].Cells[2].FindControl("lb_Location");
TextBox lb_Quantity = (TextBox)Gridview3.Rows[i].Cells[7].FindControl("lb_Quantity");
DropDownList ddlMonth = (DropDownList)Gridview3.Rows[i].Cells[8].FindControl("ddlMonth");
DropDownList ddl_ItemList = (DropDownList)Gridview3.Rows[i].Cells[4].FindControl("ddl_ItemList");
if (lb_CustomerName.Text == string.Empty)
{
var message1 = new JavaScriptSerializer().Serialize("Please enter Customer Name.");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
//ClientScript.RegisterStartupScript(this.GetType(), "alert", "ShowPopup();", true);
//this.lblMessage.Text = "Please enter Customer Name.";
flag = false;
lb_CustomerName.Focus();
break;
}
else if (lb_Location.Text == string.Empty)
{
var message1 = new JavaScriptSerializer().Serialize("Please enter Location.");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
flag = false;
lb_Location.Focus();
break;
}
else if (ddl_ItemList.SelectedIndex == 0)
{
var message1 = new JavaScriptSerializer().Serialize("Please Select Product.");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
ddl_ItemList.Focus();
flag = false;
break;
}
else if (lb_Quantity.Text == string.Empty && lb_Quantity.Text == "0")
{
var message1 = new JavaScriptSerializer().Serialize("Please enter Quantity.");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
lb_Quantity.Focus();
flag = false;
break;
}
else if (ddlMonth.SelectedValue == "0")
{
var message1 = new JavaScriptSerializer().Serialize("Please select Month.");
var script1 = string.Format("alert({0});", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
ddlMonth.Focus();
flag = false;
break;
}
}
//Checked validations of Gridview fields
if (flag == true)
{
//Created Lines in SQL InternalDB Database's [Secondary Sales Details] Table
string ItemNo = string.Empty;
string Description = string.Empty;
String strConnString = ConfigurationManager.ConnectionStrings["WA_JAYCHEM_INTDB"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
for (int i = 0; i < dtCurrentTable.Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_SecondarySalesDetails";
String[] CodeAndDesc = dtCurrentTable.Rows[i]["ItemList"].ToString().Split('-');
if (CodeAndDesc.Length >= 1)
{
ItemNo = CodeAndDesc[0].Trim();
Description = CodeAndDesc[1].Trim();
}
//string[] sDate = Convert.ToString(dtCurrentTable.Rows[i]["Date"]).Split('/');
//string sDateTime = sDate[1] + '/' + sDate[2];
string st = "01/" + dtCurrentTable.Rows[i]["Month"] + "/" + DateTime.Now.Year.ToString();
DateTime dtt = Convert.ToDateTime(st);
DateTimeFormatInfo dinfo = new DateTimeFormatInfo();
string MonthYear = dinfo.GetMonthName(Convert.ToInt16(dtCurrentTable.Rows[i]["Month"])) + "-" + DateTime.Now.Year.ToString();
cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = Convert.ToDateTime(dtt);
cmd.Parameters.Add("@CustomerName", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["CustomerName"]);
cmd.Parameters.Add("@Location", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["Location"]);
cmd.Parameters.Add("@ItemNo", SqlDbType.VarChar).Value = Convert.ToString(ItemNo);
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = Convert.ToString(Description);
cmd.Parameters.Add("@ItemCategoryCode", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["ProductCategory"]);
cmd.Parameters.Add("@Range", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["Range"]);
cmd.Parameters.Add("@Quantity", SqlDbType.VarChar).Value = Convert.ToDecimal(dtCurrentTable.Rows[i]["Quantity"]);
cmd.Parameters.Add("@MonthYear", SqlDbType.VarChar).Value = Convert.ToString(MonthYear);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
con.Dispose();
}
//Created Lines in SQL InternalDB Database's [Secondary Sales Details] Table
//Deleted SecondarySales.xls files if exist in Shared Folder
string path = ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls";
FileInfo file = new FileInfo(path);
if (file.Exists)//check file exsit or not
{
file.Delete();
}
//Deleted SecondarySales.xls files if exist in Shared Folder
//Generated SecondarySales.xls file in Shared Folder with Design of excel
string Desc = string.Empty;
StreamWriter wr = new StreamWriter(ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls");
try
{
wr.Write("<HTML><HEAD>");
wr.Write("<style> {font-family:Verdana; font-size: 11px; } </style>");
wr.Write("</HEAD><BODY>");
wr.Write("<TABLE border='1' width='100%' >");
wr.Write("<TR>");
for (int i = 0; i < dt.Columns.Count; i++)
{
wr.Write("<TD align='center' style='color: White; font-weight: bold;background-color:#8A0886;font-size: 12px'>");
wr.Write(dt.Columns[i].ToString().ToUpper() + "\t");
wr.Write("</TD>");
}
wr.Write("</TR>");
wr.WriteLine();
for (int i = 0; i < (dt.Rows.Count); i++)
{
wr.Write("<TR>");
for (int j = 0; j < dt.Columns.Count; j++)
{
wr.Write("<style> {font-family:Verdana; font-size: 11px; } </style>");
wr.Write("<TD align='center'>");
if (dt.Rows[i][j] != null)
{
if (dt.Rows[i][j] == dt.Rows[i][4])
{
String[] CodeAndDesc = dt.Rows[i][4].ToString().Split('-');
if (CodeAndDesc.Length >= 1)
{
ItemNo = CodeAndDesc[0];
Desc = CodeAndDesc[1].Trim();
}
wr.Write(Convert.ToString(Desc).ToUpper() + "\t");
}
else if (dt.Rows[i][j] == dt.Rows[i][8])
{
DateTimeFormatInfo dinfo = new DateTimeFormatInfo();
string MonthYear12 = Convert.ToString(dinfo.GetMonthName(Convert.ToInt16(dt.Rows[i]["Month"])));// + "-" + DateTime.Now.Year.ToString()
wr.Write((MonthYear12).ToUpper() + "-" + DateTime.Now.Year.ToString() + "\t");
}
else if (dt.Rows[i][j] == dt.Rows[i][3])
{
wr.Write(ItemNo + "\t");
}
else
{
wr.Write(Convert.ToString(dt.Rows[i][j]).ToUpper() + "\t");
}
}
else
{
wr.Write("\t");
}
wr.WriteLine();
wr.Write("</TD>");
}
wr.Write("</TR>");
}
wr.Write("</TABLE>");
wr.Write("</BODY>");
wr.Close();
//Generated SecondarySales.xls file in Shared Folder with Design of excel
//Mailing to Agents Email as well as General Ledger's Secondary Sales Internal Email
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.SendMailForSecondarySalesExcel(ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls", Convert.ToString(Request["CompanyCode"]));
objser1 = null;
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
var message1 = new JavaScriptSerializer().Serialize("Mail Sent successfully.");
var script1 = string.Format("alert({0});window.location='DashBoard.aspx';", message1);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true);
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
protected void btn_delete_Command(object sender, CommandEventArgs e)
{
try
{
LinkButton btn_Delete = (LinkButton)sender;
RepeaterItem item = (RepeaterItem)btn_Delete.NamingContainer;
HiddenField ItemNo = (HiddenField)item.FindControl("hf_ItemNo");
HiddenField LineNo = (HiddenField)item.FindControl("hf_LineNo");
HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped");
if (Convert.ToDecimal(hf_QuantityShipped.Value) > 0)
{
var message2 = new JavaScriptSerializer().Serialize("Shipped product could not be deleted.");
var script2 = string.Format("alert({0});", message2);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script2, true);
BindCartData();
}
else
{
NetworkCredential NetCredentialsOrder = new NetworkCredential();
NetCredentialsOrder.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentialsOrder.Password = ConfigurationManager.AppSettings["Password"];
//delete For Sales Order Line
Web_Order_Mail objserSalesOrder = new Web_Order_Mail();
objserSalesOrder.UseDefaultCredentials = true;
objserSalesOrder.Credentials = NetCredentialsOrder;
objserSalesOrder.DeleteSalesLine(Convert.ToInt16(ConfigurationManager.AppSettings["SalesOrderDocumentType"]), Convert.ToString(Request["OrderNo"]), Convert.ToInt32(LineNo.Value), ItemNo.Value, true);
objserSalesOrder = null;
//delete For Blanket Order Line
Web_Order_Mail objserBlkOrder = new Web_Order_Mail();
objserBlkOrder.UseDefaultCredentials = true;
objserBlkOrder.Credentials = NetCredentialsOrder;
objserBlkOrder.DeleteSalesLine(Convert.ToInt16(ConfigurationManager.AppSettings["DocumentType"]), Convert.ToString(Request.QueryString["BlanketOrderNo"]), Convert.ToInt32(LineNo.Value), ItemNo.Value, true);
objserBlkOrder = null;
//list = Qtm.Lib.OrderModifiCustomerInfo.ListDeleteItemLine(Request["OrderNo"].ToString(), ItemNo.Value, LineNo.Value, Convert.ToString(Request.QueryString["BlanketOrderNo"]));
SalesOrderStatistics so = new SalesOrderStatistics();
NetworkCredential NetCredentials = new NetworkCredential();
NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"];
NetCredentials.Password = ConfigurationManager.AppSettings["Password"];
Web_Order_Mail objser1 = new Web_Order_Mail();
objser1.UseDefaultCredentials = true;
objser1.Credentials = NetCredentials;
objser1.SalesOrderStatistics(Convert.ToString(Request.QueryString["OrderNo"]));
objser1 = null;
if (list != null && list.Count > 0)
{
rpt_FinalCart.DataSource = list;
rpt_FinalCart.DataBind();
}
else
{
rpt_FinalCart.DataSource = null;
rpt_FinalCart.DataBind();
l_Error.Visible = true;
}
BindCartData();
}
}
catch (Exception ex)
{
var message = new JavaScriptSerializer().Serialize(ex.Message.ToString());
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true);
}
}
