protected void FillBusinessUnitsForLoginType3()
{
DataTable dt = new DataTable();
string query = "select distinct bm.bu_code,bu_desc from ax.acxsitebumapping sbp join ax.ACXBUMASTER bm on bm.bu_code = sbp.BU_CODE where SITEID in ('" + GetStringValueCommaSeparted(ucRoleFilters.GetCommaSepartedSiteId()) + "')";
dt = new DataTable();
dt = baseObj.GetData(query);
ChkBunt.Items.Clear();
ChkBunt.DataSource = dt;
ChkBunt.DataTextField = "bu_desc";
ChkBunt.DataValueField = "bu_code";
ChkBunt.DataBind();
}
protected void BindGridview()
{
try
{
string query;
query = "EXEC [dbo].[ACX_GETPENDINGSO] '" + Session["SiteCode"].ToString() + "'";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
DataTable dt = new DataTable();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
dt = SortDataView(dt);
gvHeader.DataSource = dt;
gvHeader.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvHeader.DataSource = dt;
gvHeader.DataBind();
int columncount = gvHeader.Rows[0].Cells.Count;
gvHeader.Rows[0].Cells.Clear();
gvHeader.Rows[0].Cells.Add(new TableCell());
gvHeader.Rows[0].Cells[0].ColumnSpan = columncount;
gvHeader.Rows[0].Cells[0].Text = "No Records Found";
}
Session["SaleOrderSearch"] = dt;
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void BindGridview(string param)
{
try
{
string query;
query = @"Select A.INVOICE_NO,A.INVOIC_DATE,A.INVOICE_VALUE,A.SITEID as DistCode,DistName = (select Name from [ax].[INVENTSITE] where SITEID = A.SITEID)
from [ax].[ACXSALEINVOICEHEADER] A left Join [ax].[ACXPURCHINVRECIEPTHEADER] B on B.Site_Code=A.Customer_Code
and B.Supplier_Code=A.SiteID and B.Sale_InvoiceNo=A.Invoice_NO inner join [ax].[ACXUSERMASTER] C on C.Site_Code = A.CUSTOMER_CODE
Where B.Sale_InvoiceNo is null and A.Trantype<>2 and A.INVOIC_DATE >= C.PurchaseStartDate and
(SELECT ISNULL(SUM(BOX),0) FROM [ax].[ACXSALEINVOICELINE] SL WHERE SL.SITEID=A.SITEID AND SL.INVOICE_NO=A.INVOICE_NO)
>(SELECT ISNULL(SUM(BOX),0) FROM [ax].[ACXSALEINVOICELINE] SL JOIN AX.ACXSALEINVOICEHEADER SH ON SH.SITEID=SL.SITEID
AND SH.INVOICE_NO=SL.INVOICE_NO AND SL.SITEID=A.SITEID AND SH.SO_NO=A.INVOICE_NO AND SL.TRANTYPE=2)and A.Customer_Code='" + Session["SiteCode"].ToString() + param + "' Order by A.SITEID,A.INVOICE_NO ";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
DataTable dt = new DataTable();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvHeader.DataSource = dt;
gvHeader.DataBind();
}
else
{
gvHeader.DataSource = null;
gvHeader.DataBind();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void GetPSRBeat()
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query = " Select A.PSRCode,C.PSR_Name as PSRName,A.BeatCode,A.BeatName,d.Discription as BeatDayDesc " +
" from AX.ACXPSRBEATMASTER A " +
" inner JOIN AX.ACXPSRSITELinkingMaster B ON A.PSRCode = B.PSRCode and A.Site_code = B.Site_Code " +
" inner Join ax.[ACXPSRMaster] c on A.PSRCode = C.PSR_Code " +
" left Join ax.ACXWeekMaster d on d.DayCode=A.BeatDay " +
" where B.Site_Code='" + Session["SiteCode"].ToString() + "'" +
" order By C.PSR_Name,A.BeatName ";
DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvDetails.DataSource = dt;
gvDetails.DataBind();
}
}
catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); }
}
private void GetPSRCustomer()
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query = " Select A.CustomerCode,A.CustomerName ," +
" A.PSRCode,PSRName=(select C.PSR_Name from [ax].[ACXPSRMaster] C where C.PSR_Code=A.PSRCode )," +
" A.BeatCode,B.BeatName,B.BeatDay,BeatDayDesc=(Select F.Discription from ax.ACXWeekMaster F where F.DayCode=B.BeatDay) " +
" from [ax].[ACXPSRCUSTLinkingMaster] A " +
" Left Join [ax].[ACXPSRBeatMaster] B on A.BeatCode=B.BeatCode and A.PSRCode=b.PSRCode AND A.SITE_CODE = B.SITE_CODE " +
" Left Join [ax].[ACXCUSTMASTER] C on A.CustomerCode=C.Customer_Code AND A.SITE_CODE = C.SITE_CODE " +
" where A.Site_Code='" + Session["SiteCode"].ToString() + "' and C.Blocked = 0 order by PSRName,BeatName,A.CustomerName";
DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvDetails.DataSource = dt;
gvDetails.DataBind();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void LoadSiteIDDetails()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query = "Select NAME , ACXADDRESS1 + ACXADDRESS2 + ',' + ACXCITY AS SITEADDRESS from ax.inventsite where SITEID='" + Session["SiteCode"] + "'";
System.Data.DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
lblAddress.Text = dt.Rows[0]["SITEADDRESS"].ToString();
}
}
protected void lnkbtn_Click(object sender, EventArgs e)
{
try
{
GridViewRow gvrow = (GridViewRow)(((LinkButton)sender)).NamingContainer;
LinkButton lnk = sender as LinkButton;
Session["Lndentno"] = lnk.Text;
DataTable dt = new DataTable();
string query;
//query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," +
// "Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " +
// "B.Product_GRoup=A.Product_Group)," +
// "cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " +
// "from ax.ACXPurchIndentLine A Where A.Indent_No='" + lnk.Text + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no";
query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," +
"Product_Name=(Select B.Product_Name from ax.INVENTTABLE B where B.Itemid=A.Product_Code and " +
"B.Product_GRoup=A.Product_Group)," +
"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " +
"from ax.ACXPurchIndentLine A Where A.Indent_No='" + lnk.Text + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
int columncount = gvHeader.Rows[0].Cells.Count;
gvLineDetails.Rows[0].Cells.Clear();
gvLineDetails.Rows[0].Cells.Add(new TableCell());
gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount;
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
}
}
protected void SONo_CheckedChanged(object sender, EventArgs e)
{
try
{
GridViewRow gvrow = (GridViewRow)(((LinkButton)sender)).NamingContainer;
CheckBox lnk = sender as CheckBox;
DataTable dt = new DataTable();
string query = "Select B.SO_NO,CONVERT(VARCHAR(11),B.SO_Date,106) as SO_Date," +
"Customer_Group=(select C.CustGroup_Name from ax.ACXCUSTGROUPMASTER C where C.CustGroup_Code=D.Cust_Group)," +
"Concat(D.Customer_Code,'-',D.Customer_Name) as customer," +
"E.Product_Group, E.ItemId+'-'+E.Product_Name as Product," +
"cast(A.BOX as decimal(10,2)) as BOX,cast(A.Crates as decimal(10,2)) as Crates,cast(A.Ltr as decimal(10,2)) as Ltr " +
" from ax.ACXLOADSHEETLINE A" +
" left join ax.ACXLOADSHEETHEADER B on A.LoadSheet_No=B.LoadSheet_No" +
" left join ax.Acxcustmaster D on D.Customer_Code=B.Customer_Code" +
// " left Join ax.ACXProductMaster E on A.Product_COde=E.Product_Code" +
" left Join ax.InventTable E on A.Product_COde=E.ItemId" +
" Where B.SO_NO='" + lnk.Text + "' and A.SHITEID='" + Session["SiteCode"].ToString() + "'" +
" Order By A.Line_No";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
int columncount = gvHeader.Rows[0].Cells.Count;
gvLineDetails.Rows[0].Cells.Clear();
gvLineDetails.Rows[0].Cells.Add(new TableCell());
gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount;
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
}
}
public void BindLineItem()
{
try
{
DataTable dt = new DataTable();
string query = "select A.SO_NO,CONVERT(VARCHAR(11),B.[SO_DATE],106) as SO_Date," +
"Customer_Group=(select C.CustGroup_Name from ax.ACXCUSTGROUPMASTER C where C.CustGroup_Code=D.Cust_Group),Concat (D.Customer_Code,'-',D.Customer_Name) as customer," +
"Concat(D.Customer_Code,'-',D.Customer_Name) as customer," +
"E.Product_Group, E.ItemId+'-'+E.Product_Name as Product,cast(A.BOX as decimal(10,2)) as BOX,cast(A.Crates as decimal(10,2)) as Crates,cast(A.Ltr as decimal(10,2)) as Ltr" +
" from ax.ACXSALESLINE A left join [ax].[ACXSALESHEADER] B on A.SO_NO=B.SO_NO left join ax.Acxcustmaster D on D.Customer_Code=B.Customer_Code left Join ax.InventTable E on A.Product_COde=E.ItemId" +
" Where B.SO_NO='" + Session["SO_NO"].ToString() + "' and A.SITEID='" + Session["SiteCode"].ToString() + "'" +
" Order By A.Line_No";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
int columncount = gvLineDetails.Rows[0].Cells.Count;
gvLineDetails.Rows[0].Cells.Clear();
gvLineDetails.Rows[0].Cells.Add(new TableCell());
gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount;
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
}
}
protected void BindGridview()
{
try
{
string query;
query = "Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),Required_Date,106),'') as Required_Date," +
// "SALEOFFICE_CODE=(select B.SALEOFFICE_CODE from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," +
"SALEOFFICE_CODE=(select B.ACXPLANTCODE from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," +
//"SALEOFFICE_NAME=(select B.SALEOFFICE_NAME from ax.ACXSITEMASTER B where B.SiteId=A.SiteId ),"+
"SALEOFFICE_NAME=(select B.ACXPLANTNAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," +
"Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
"Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
"Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
"A.So_No, A.Invoice_No ," +
" case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm " +
"from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and [Siteid]='" + Session["SiteCode"].ToString() + "' order by A.Indent_Date desc";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
DataTable dt = new DataTable();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvHeader.DataSource = dt;
gvHeader.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvHeader.DataSource = dt;
gvHeader.DataBind();
int columncount = gvHeader.Rows[0].Cells.Count;
gvHeader.Rows[0].Cells.Clear();
gvHeader.Rows[0].Cells.Add(new TableCell());
gvHeader.Rows[0].Cells[0].ColumnSpan = columncount;
gvHeader.Rows[0].Cells[0].Text = "No Records Found";
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
public void BindNewLine()
{
try
{
DataTable dt = new DataTable();
string query;
query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," +
"Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " +
"B.Product_GRoup=A.Product_Group)," +
"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " +
"from ax.ACXPurchIndentLine A Where A.Indent_No='" + Session["IndentNo"].ToString() + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
gvLineDetails.DataSource = dt;
gvLineDetails.DataBind();
int columncount = gvHeader.Rows[0].Cells.Count;
gvLineDetails.Rows[0].Cells.Clear();
gvLineDetails.Rows[0].Cells.Add(new TableCell());
gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount;
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
}
}
private void GetPSRDistributorLinking()
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query = " Select A.Site_Code,Site_Name=(select B.Name from [ax].[INVENTSITE] B where B.SITEID=A.Site_Code)," +
" A.PSRCode,PSRName=(select C.PSR_Name from [ax].[ACXPSRMaster] C where C.PSR_Code=A.PSRCode)," +
" CONVERT(VARCHAR(11),A.[FromDate],106) as [FromDate],CONVERT(VARCHAR(11),A.[TODate],106) as [TODate]" +
" from [ax].[ACXPSRSITELinkingMaster] A where A.Site_Code='" + Session["SiteCode"].ToString() + "' and A.Blocked=0 Order By PSRName,A.[FromDate] Desc";
DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvDetails.DataSource = dt;
gvDetails.DataBind();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void checkAll_CheckedChanged(object sender, EventArgs e)
{
string strSONO = string.Empty;
DataTable dt = new DataTable();
foreach (GridViewRow row in gvDetails.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chkStatus") as CheckBox);
if (chkRow.Checked)
{
//strSONO += "'" + chkRow.Text + "',"; //getting all So_No those are checked by User
strSONO += "" + chkRow.Text + ",";
}
}
}
//==============For Warehouse Loacion 11-5-16===========
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string TransLocation = "";
string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'";
dt = new DataTable();
dt = obj.GetData(query1);
if (dt.Rows.Count > 0)
{
TransLocation = dt.Rows[0]["MainWarehouse"].ToString();
}
//====================================
if (strSONO != string.Empty)
{
strSONO = strSONO.Remove(strSONO.Length - 1);
//==============11-5-16========
//string strSaleLine = "Select AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,Sum(AL.CRATES) as CRATES,Sum(AL.BOX) AS BOX,Sum(AL.LTR) AS LTR " +
// ",StockBox=(Select coalesce(cast(sum(F.TransQty) as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" +
// ",StockLtr =(Select coalesce(cast((sum(F.TransQty)*AP.Product_PackSize*AP.LTR)/1000 as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" +
// " from [ax].[ACXSALESLINE] AL Inner Join [ax].[InventTable] AP on AL.PRODUCT_CODE = AP.ItemId " +
// " where SO_No In (" + strSONO + ") and AL.SiteId='" + Session["SiteCode"].ToString() + "' group by AL.SITEID,AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,AP.Product_PackSize,AP.LTR";
string strSaleLine = "EXEC ACX_GETLOADSHEET '" + Session["SiteCode"].ToString() + "','" + TransLocation + "','" + strSONO + "'";
dt = baseObj.GetData(strSaleLine);
if (dt.Rows.Count > 0)
{
GridView2.Visible = true;
GridView2.DataSource = dt;
GridView2.DataBind();
}
else
{
dt = null;
GridView2.Visible = false;
GridView2.DataSource = dt;
GridView2.DataBind();
}
}
else
{
dt = null;
GridView2.DataSource = dt;
GridView2.DataBind();
}
//UppnalegridDetails.Update();
}
protected void btn2_Click(object sender, EventArgs e)
{
if (txtSearch.Text != "" || ddlSerch.SelectedItem.Text == "All")
{
gvHeader.DataSource = null;
gvHeader.DataBind();
gvLineDetails.DataSource = null;
gvLineDetails.DataBind();
if (ddlSerch.SelectedItem.Text == "All")
{
BindGridview();
}
else
{
string search = "";
search = "%" + txtSearch.Text + "%";
try
{
string query;
//string query = "Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),Required_Date,106),'') as Required_Date," +
// //"SALEOFFICE_CODE=(select B.SALEOFFICE_CODE from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," +
//"SALEOFFICE_CODE=(select B.ACXPLANTCODE from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," +
// //"SALEOFFICE_NAME=(select B.SALEOFFICE_NAME from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," +
//"SALEOFFICE_NAME=(select B.ACXPLANTNAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," +
//"Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
//"Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
//"Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," +
//" A.So_No, A.Invoice_No ," +
//" case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm " +
//"from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and [Siteid]='" + Session["SiteCode"].ToString() + "' and A." + ddlSerch.SelectedItem.Value + " like '" + search + "' order by A.Indent_No";
string searchitem = ddlSerch.SelectedItem.Value;
if (searchitem == "Customer_Code")
{
searchitem = "SiteID";
query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date,
DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ),
DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId),
Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm
from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and
A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and A." + searchitem + " like '" + search + "' " +
" and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc ";
}
else if (searchitem == "Customer_Name")
{
query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date,
DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ),
DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId),
Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm
from ax.ACXPURCHINDENTHEADER A Inner Join [ax].[INVENTSITE] B on B.SiteId=A.SiteId where A.indent_No!='' and
A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and B.NAME like '" + search + "' " +
" and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc ";
}
else
{
query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date,
DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ),
DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId),
Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ),
A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm
from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and
A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and A." + searchitem + " like '" + search + "' " +
" and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc ";
}
DataTable dt = new DataTable();
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
gvHeader.DataSource = dt;
gvHeader.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true);
}
//===============================================
// dt.Clear();
// search = txtSearch.Text;
// // query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," +
// //"Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " +
// //"B.Product_GRoup=A.Product_Group)," +
// //"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " +
// //"from ax.ACXPurchIndentLine A Where A." + ddlSerch.SelectedItem.Value + "='" + search + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no";
// query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," +
//"Product_Name=(Select B.Product_Name from ax.INVENTTABLE B where B.Itemid=A.Product_Code and " +
//"B.Product_GRoup=A.Product_Group)," +
//"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " +
//"from ax.ACXPurchIndentLine A Where A." + ddlSerch.SelectedItem.Value + "='" + search + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no";
// dt = obj.GetData(query);
// if (dt.Rows.Count > 0)
// {
// gvLineDetails.DataSource = dt;
// gvLineDetails.DataBind();
// }
// else
// {
// //ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true);
// }
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Enter the text in serchbox..')", true);
}
}
public void UpdateTransTable(string PostedDocumentNo, SqlTransaction trans, SqlConnection conn)
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string TransLocation = "";
string TransId = string.Empty;
string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'";
DataTable dt = new DataTable();
dt = obj.GetData(query1);
if (dt.Rows.Count > 0)
{
TransLocation = dt.Rows[0]["MainWarehouse"].ToString();
}
string queryInsert = " Insert Into ax.acxinventTrans " +
"([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," +
"[DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" +
" Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " +
" @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)";
cmd = new SqlCommand(queryInsert);
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.Text;
string st = Session["SiteCode"].ToString();
if (st.Length <= 6)
{
TransId = st + System.DateTime.Now.ToString("yymmddhhmmss");
}
else
{
TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss");
}
for (int p = 0; p < GridPurchItems.Rows.Count; p++)
{
string Siteid = Session["SiteCode"].ToString();
string DATAAREAID = Session["DATAAREAID"].ToString();
int TransType = 1; // Type 1 for Purchase Invoice Receipt
int DocumentType = 1;
string DocumentNo = PostedDocumentNo;
string productNameCode = GridPurchItems.Rows[p].Cells[2].Text;
string[] str = productNameCode.Split('-');
string ProductCode = str[0].ToString();
string box = GridPurchItems.Rows[p].Cells[4].Text;
decimal TransQty = Convert.ToDecimal(box) * 1;
string UOM = GridPurchItems.Rows[p].Cells[6].Text;
string Referencedocumentno = PostedDocumentNo;
int REcid = p + 1;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@TransId", TransId);
cmd.Parameters.AddWithValue("@SiteCode", Siteid);
cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID);
cmd.Parameters.AddWithValue("@RECID", p + 1);
cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now);
cmd.Parameters.AddWithValue("@TransType", TransType);
cmd.Parameters.AddWithValue("@DocumentType", DocumentType);
cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo);
cmd.Parameters.AddWithValue("@DocumentDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ProductCode", ProductCode);
cmd.Parameters.AddWithValue("@TransQty", TransQty);
cmd.Parameters.AddWithValue("@TransUOM", UOM);
cmd.Parameters.AddWithValue("@TransLocation", TransLocation);
cmd.Parameters.AddWithValue("@Referencedocumentno", Referencedocumentno);
int i = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
transaction.Rollback();
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
#region old Code PROCEDURE ISSUE
//try
//{
// CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
// conn = obj.GetConnection();
// string TransLocation = "";
// string TransId = string.Empty;
// string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'";
// DataTable dt = new DataTable();
// dt = obj.GetData(query1);
// if (dt.Rows.Count > 0)
// {
// TransLocation = dt.Rows[0]["MainWarehouse"].ToString();
// }
// string st = Session["SiteCode"].ToString();
// if (st.Length <= 6)
// {
// TransId = st + System.DateTime.Now.ToString("yymmddhhmmss");
// }
// else
// {
// TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss");
// }
// cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.CommandTimeout = 100;
// cmd.CommandText = string.Empty;
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText = "[ACX_PURCHINVC_UPDATEINVENTTRANS]";
// cmd.Parameters.Clear();
// string strSite = Session["SiteCode"].ToString();
// string strDAtaArea = Session["DATAAREAID"].ToString();
// cmd.Parameters.AddWithValue("@SITECODE", strSite);
// cmd.Parameters.AddWithValue("@DOCUMENTPURCHRECEIPTNUMBER", PostedDocumentNo);
// cmd.Parameters.AddWithValue("@DATAAREAID", strDAtaArea);
// cmd.Parameters.AddWithValue("@TRANSID", TransId);
// cmd.Parameters.AddWithValue("@WAREHOUSE", TransLocation);
// cmd.Parameters.AddWithValue("@TRANSTYPE", 1);
// int i = cmd.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
// LblMessage.Text = "Error: Inventory Update Issue - " + ex.Message.ToString();
//}
//finally
//{
// if (conn != null)
// {
// if (conn.State == ConnectionState.Open)
// {
// conn.Close();
// }
// }
//}
#endregion
}
private void SaveManualPurchaseReturnToInventTransTable(string PurcReturnCode, SqlTransaction trans, SqlConnection conn, int Qty)
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string TransLocation = "";
if (Qty < 0)
{
string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "' ";
DataTable dt = new DataTable();
dt = obj.GetData(query1);
if (dt.Rows.Count > 0)
{
TransLocation = dt.Rows[0]["MainWarehouse"].ToString();
}
}
else
{
string query1 = "Select INVENTLOCATIONID from Ax.inventlocation where InventSiteid = '" + Session["SiteCode"].ToString() + "' and ACX_WAREHOUSETYPE = 1";
DataTable dt = new DataTable();
dt = obj.GetData(query1);
if (dt.Rows.Count > 0)
{
TransLocation = dt.Rows[0]["INVENTLOCATIONID"].ToString();
}
}
string queryInsert = " Insert Into ax.acxinventTrans " +
"([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," +
"[DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" +
" Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " +
" @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)";
cmd = new SqlCommand(queryInsert);
cmd.Connection = conn;
cmd.Transaction = trans;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.Text;
string st = Session["SiteCode"].ToString();
for (int i = 0; i < gvDetails.Rows.Count; i++)
{
string TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss");
string Siteid = Session["SiteCode"].ToString();
string DATAAREAID = Session["DATAAREAID"].ToString();
int TransType = 8; // Type 5 for Manual Purchase Return
int DocumentType = 8;
string DocumentNo = PurcReturnCode;
string productNameCode = gvDetails.Rows[i].Cells[2].Text;
string[] str = productNameCode.Split('-');
string ProductCode = str[0].ToString();
TextBox txtBoxQty = (TextBox)gvDetails.Rows[i].Cells[4].FindControl("txtQty");
string strqty = txtBoxQty.Text;
decimal TransQty = Convert.ToDecimal(strqty) * Qty;
string UOM = gvDetails.Rows[i].Cells[7].Text;
string Referencedocumentno = ddlInvoceNo.Text;// PurcReturnCode;
int REcid = i + 1;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@TransId", TransId);
cmd.Parameters.AddWithValue("@SiteCode", Siteid);
cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID);
cmd.Parameters.AddWithValue("@RECID", i + 1);
cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now);
cmd.Parameters.AddWithValue("@TransType", TransType);
cmd.Parameters.AddWithValue("@DocumentType", DocumentType);
cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo);
cmd.Parameters.AddWithValue("@DocumentDate", DateTime.Now);
cmd.Parameters.AddWithValue("@ProductCode", ProductCode);
cmd.Parameters.AddWithValue("@TransQty", TransQty);
cmd.Parameters.AddWithValue("@TransUOM", UOM);
cmd.Parameters.AddWithValue("@TransLocation", TransLocation);
cmd.Parameters.AddWithValue("@Referencedocumentno", ddlInvoceNo.SelectedItem.Value);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
transaction.Rollback();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void chkStatus_OnCheckedChanged(object sender, EventArgs e) //sale Header Grid View for Filling the Sale Line
{
try
{
string strSONO = string.Empty;
DataTable dt = new DataTable();
foreach (GridViewRow row in gvDetails.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chkStatus") as CheckBox);
if (chkRow.Checked)
{
//strSONO += "'" + chkRow.Text + "',"; //getting all So_No those are checked by User
strSONO += "" + chkRow.Text + ",";
}
}
}
//==============For Warehouse Loacion 11-5-16===========
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string TransLocation = "";
string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'";
dt = new DataTable();
dt = obj.GetData(query1);
if (dt.Rows.Count > 0)
{
TransLocation = dt.Rows[0]["MainWarehouse"].ToString();
}
//====================================
if (strSONO != string.Empty)
{
strSONO = strSONO.Remove(strSONO.Length - 1);
//==============11-5-16========
//string strSaleLine = "Select AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,Sum(AL.CRATES) as CRATES,cast(Sum(AL.BOX) as integer) As BOX,cast(Sum(AL.BOX) as decimal(9,2)) As TotalQty,Sum(AL.LTR) AS LTR ,Cast(Round((cast(Sum(AL.BOX) as decimal(9,2))-cast(Sum(AL.BOX) as integer))*AP.Product_PackSize,2) as integer) as PCS,AP.Product_PackSize" +
// ",StockBox=(Select coalesce(cast(sum(F.TransQty) as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" +
// ",StockLtr =(Select coalesce(cast((sum(F.TransQty)*AP.Product_PackSize*AP.LTR)/1000 as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" +
// " from [ax].[ACXSALESLINE] AL Inner Join [ax].[InventTable] AP on AL.PRODUCT_CODE = AP.ItemId " +
// " where SO_No In (" + strSONO + ") and AL.SiteId='" + Session["SiteCode"].ToString() + "' group by AL.SITEID,AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,AP.Product_PackSize,AP.LTR";
string strSaleLine = "EXEC ACX_GETLOADSHEET '" + Session["SiteCode"].ToString() + "','" + TransLocation + "','" + strSONO + "'";
dt = baseObj.GetData(strSaleLine);
if (dt.Rows.Count > 0)
{
GridView2.Visible = true;
GridView2.DataSource = dt;
GridView2.DataBind();
GridView2.FooterRow.Cells[2].Text = "Total :";
GridView2.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[2].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[2].Font.Bold = true;
decimal Crates = dt.AsEnumerable().Sum(row => row.Field <decimal>("CRATES"));
GridView2.FooterRow.Cells[3].Text = Crates.ToString("N2");
GridView2.FooterRow.Cells[3].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[3].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[3].Font.Bold = true;
int BoxQty = dt.AsEnumerable().Sum(row => row.Field <int>("BOX"));
GridView2.FooterRow.Cells[4].Text = BoxQty.ToString();
GridView2.FooterRow.Cells[4].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[4].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[4].Font.Bold = true;
int PCS = dt.AsEnumerable().Sum(row => row.Field <int>("PCS"));
GridView2.FooterRow.Cells[5].Text = PCS.ToString();
GridView2.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[5].Font.Bold = true;
decimal TotalQtyConv = dt.AsEnumerable().Sum(row => row.Field <decimal>("TotalQty"));
GridView2.FooterRow.Cells[6].Text = TotalQtyConv.ToString("N2");
GridView2.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[6].Font.Bold = true;
decimal ltr = dt.AsEnumerable().Sum(row => row.Field <decimal>("LTR"));
GridView2.FooterRow.Cells[8].Text = ltr.ToString("N2");
GridView2.FooterRow.Cells[8].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[8].Font.Bold = true;
}
else
{
dt = null;
GridView2.DataSource = dt;
GridView2.DataBind();
}
}
else
{
dt = null;
GridView2.DataSource = dt;
GridView2.DataBind();
}
//UppnalegridDetails.Update();
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void ShowData(string CustID)
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query = " Select *, B.CUSTGROUP_NAME, C.PSR_Name,D.BeatName,CG.Description As ChannelGroupName,CT.SubSegmentDescription As ChannelTypeName " +
" FROM [ax].[ACXCUSTMASTER] A " +
" LEFT OUTER JOIN [AX].[ACXSMMBUSRELSEGMENTGROUP] CG ON CG.SegmentID= A.CHANNELGROUP " +
" LEFT OUTER JOIN [AX].[ACXSMMBUSRELSUBSEGMENTGROUP] CT ON CT.SubSegmentID= A.CHANNELTYPE " +
" LEFT OUTER JOIN ax.ACXCUSTGROUPMASTER B ON A.CUST_GROUP=B.CUSTGROUP_CODE " +
" LEFT OUTER JOIN [ax].[ACXPSRMaster] C ON A.PSR_CODE=C.PSR_Code LEFT OUTER JOIN " +
" [ax].[ACXPSRBeatMaster] D ON A.PSR_BEAT = D.BeatCode and A.SITE_CODE=D.Site_code where Customer_Code ='" + CustID + "' and A.BLOCKED=0";
System.Data.DataTable dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
LiteralCustID.Text = "[" + Request.QueryString["CustID"].ToString() + "] ";
txtCustomerName.Text = dt.Rows[0]["Customer_Name"].ToString();
txtCustomerName.Font.Bold = true;
txtContactPerson.Text = dt.Rows[0]["Contact_Name"].ToString();
txtAddress1.Text = dt.Rows[0]["Address1"].ToString();
txtAddress2.Text = dt.Rows[0]["Address2"].ToString();
txtCity.Text = dt.Rows[0]["City"].ToString();
txtZipCode.Text = dt.Rows[0]["ZipCode"].ToString();
txtArea.Text = dt.Rows[0]["Area"].ToString();
txtDistrict.Text = dt.Rows[0]["District"].ToString();
txtState.Text = dt.Rows[0]["State"].ToString();
txtMobileNo.Text = dt.Rows[0]["Mobile_No"].ToString();
txtMobileNo.Font.Bold = true;
txtPhoneNo.Text = dt.Rows[0]["Phone_No"].ToString();
txtEmailID.Text = dt.Rows[0]["EmailId"].ToString();
txtPaymentTerm.Text = dt.Rows[0]["Payment_Term"].ToString();
txtPaymentMode.Text = dt.Rows[0]["Payment_Mode"].ToString();
txtPAN.Text = dt.Rows[0]["Pan"].ToString();
txtTINVAT.Text = dt.Rows[0]["VAT"].ToString();
txtCST.Text = dt.Rows[0]["CST"].ToString();
txtTAN.Text = dt.Rows[0]["TAN"].ToString();
txtRegDate.Text = dt.Rows[0]["Register_Date"].ToString();
txtClosingDate.Text = dt.Rows[0]["Closing_Date"].ToString();
txtCustGroup.Text = "[" + dt.Rows[0]["CUST_GROUP"].ToString() + "]" + " " + dt.Rows[0]["CUSTGROUP_NAME"].ToString();
txtCustGroup.Font.Bold = true;
txtDistance.Text = string.Empty;
txtPSRName.Text = "[" + dt.Rows[0]["PSR_Code"].ToString() + "]" + " " + dt.Rows[0]["PSR_Name"].ToString();
txtPSRName.Font.Bold = true;
txtPSRBeatName.Text = "[" + dt.Rows[0]["PSR_Beat"].ToString() + "]" + " " + dt.Rows[0]["BeatName"].ToString(); //+"/" + dt.Rows[0]["PSR_Day"].ToString();
txtPSRBeatName.Font.Bold = true;
txtDeepFreeer.Text = dt.Rows[0]["Deep_Frizer"].ToString();
txtDeepFreeer.Font.Bold = true;
txtDeepFreeer.ForeColor = System.Drawing.Color.DarkGreen;
//txtChannelType.Text = dt.Rows[0]["Channel_Type"].ToString();
txtChannelGroup.Text = dt.Rows[0]["ChannelGroupName"].ToString();
txtChannelType.Text = dt.Rows[0]["ChannelTypeName"].ToString();
txtMonday.Text = dt.Rows[0]["Monday"].ToString();
txtTuesday.Text = dt.Rows[0]["Tuesday"].ToString();
txtWednesday.Text = dt.Rows[0]["Wednesday"].ToString();
txtThursday.Text = dt.Rows[0]["Thursday"].ToString();
txtFriday.Text = dt.Rows[0]["Friday"].ToString();
txtSaturday.Text = dt.Rows[0]["Saturday"].ToString();
txtSunday.Text = dt.Rows[0]["Sunday"].ToString();
txtVisitFrequency.Text = dt.Rows[0]["VISITFREQUENCY"].ToString();
txtRepeatWeek.Text = dt.Rows[0]["REPEATWEEK"].ToString();
txtSequenceno.Text = dt.Rows[0]["SEQUENCENO"].ToString();
if (Convert.ToInt32(dt.Rows[0]["Key_Customer"].ToString()) == 0)
{
txtKeyCustomer.Text = "No";
txtKeyCustomer.Font.Bold = true;
txtKeyCustomer.ForeColor = System.Drawing.Color.Red;
}
else
{
txtKeyCustomer.Text = "Yes";
txtKeyCustomer.Font.Bold = true;
txtKeyCustomer.ForeColor = System.Drawing.Color.Green;
}
//txtKeyCustomer.Text = dt.Rows[0]["Key_Customer"].ToString();
if (Convert.ToInt32(dt.Rows[0]["Blocked"].ToString()) == 0)
{
txtActiveInactive.Text = "Yes";
txtActiveInactive.Font.Bold = true;
txtActiveInactive.ForeColor = System.Drawing.Color.DarkGreen;
}
else
{
txtActiveInactive.Text = "No";
txtActiveInactive.ForeColor = System.Drawing.Color.Red;
}
string APPLICABLESCHEMEDISCOUNT;
if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "0")
{
APPLICABLESCHEMEDISCOUNT = "None";
}
else if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "1")
{
APPLICABLESCHEMEDISCOUNT = "Scheme";
}
else if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "2")
{
APPLICABLESCHEMEDISCOUNT = "Discount";
}
else
{
APPLICABLESCHEMEDISCOUNT = "Both";
}
txtOutletType.Text = dt.Rows[0]["Outlet_Type"].ToString();
txtSchemeDisc.Text = APPLICABLESCHEMEDISCOUNT; //dt.Rows[0]["Scheme_Discount"].ToString();
}
else
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('No Data Exists !');", true);
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtSearch.Text != "" || ddlSerch.SelectedItem.Text != "")
{
gvHeader.DataSource = null;
gvHeader.DataBind();
gvLineDetails.DataSource = null;
gvLineDetails.DataBind();
if (ddlSerch.SelectedItem.Text == "All")
{
BindGridview();
}
else
{
string search = "";
search = "%" + txtSearch.Text + "%";
if (Session["SaleOrderSearch"] == null)
{
string query = "EXEC [dbo].[ACX_GETPENDINGSO] '" + Session["SiteCode"].ToString() + "'";
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
DataTable dt = new DataTable();
dt = obj.GetData(query);
Session["SaleOrderSearch"] = dt;
dt = null;
}
DataTable dtSearch = (DataTable)Session["SaleOrderSearch"];
DataRow[] drSearch;
if (ddlSerch.Text == "Customer Name")
{
drSearch = dtSearch.Select("Customer_Name like '" + search + "'");
}
else if (ddlSerch.SelectedItem.Text == "Date")
{
drSearch = dtSearch.Select("SO_Date='" + Convert.ToDateTime(txtSearch.Text).ToString("dd MMM yyyy") + "'");
}
else if (ddlSerch.SelectedItem.Text == "Load Sheet No")
{
drSearch = dtSearch.Select("LoadSheet_No like '" + search + "'");
}
else if (ddlSerch.SelectedItem.Text == "Customer Group")
{
drSearch = dtSearch.Select("Customer_Group like '" + search + "'");
}
else
{
drSearch = dtSearch.Select(ddlSerch.SelectedItem.Value + " like '" + search + "'");
}
if (drSearch.Count() > 0)
{
DataTable dt = drSearch.CopyToDataTable();
dt = SortDataView(dt);
gvHeader.DataSource = dt;
gvHeader.DataBind();
CheckBox chkbox = (CheckBox)gvHeader.HeaderRow.Cells[0].FindControl("CheckAll");
chkbox.Checked = true;
chkbox.Visible = true;
foreach (GridViewRow grv in gvHeader.Rows)
{
CheckBox chkAll = (CheckBox)grv.Cells[0].FindControl("chkSONO");
chkAll.Checked = true;
}
return;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true);
return;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Enter the text in serchbox..')", true);
}
}