protected void ShowData_ForExcel()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
string FilterQuery = string.Empty;
DataTable dtSetHeader = null;
try
{
string query1 = "Select NAME from ax.inventsite where SITEID='" + Session["SiteCode"].ToString() + "'";
dtSetHeader = new DataTable();
dtSetHeader = obj.GetData(query1);
SqlConnection conn = null;
SqlCommand cmd = null;
string query = string.Empty;
conn = new SqlConnection(obj.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.StoredProcedure;
query = "[dbo].[ACX_STOCKLEDGER]";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@FromDate", txtFromDate.Text);
cmd.Parameters.AddWithValue("@ToDate", txtToDate.Text);
//cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
//cmd.Parameters.AddWithValue("@ItemId", drpProduct.SelectedItem.Value);
//cmd.Parameters.AddWithValue("@TransLocation", ddlWarehouse.SelectedItem.Value);
//ItemId
if (drpProduct.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@ItemId", drpProduct.SelectedItem.Value);
}
if (drpProduct.SelectedIndex == 0 || drpProduct.Text == "All...")
{
cmd.Parameters.AddWithValue("@ItemId", "");
}
//bucode
if (ddlBusinessUnit.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@BUCODE", ddlBusinessUnit.SelectedItem.Value);
}
if (ddlBusinessUnit.SelectedIndex == 0 || drpProduct.Text == "All...")
{
cmd.Parameters.AddWithValue("@BUCODE", "");
}
// site
if (ddlSiteId.SelectedIndex > 0)
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else if (ddlSiteId.SelectedItem.Text != "All...")
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
//WareLocation
if (ddlWarehouse.SelectedIndex >= 0)
{
cmd.Parameters.AddWithValue("@TransLocation", ddlWarehouse.SelectedItem.Value);
}
if (rdoDetail.Checked == true)
{
cmd.Parameters.AddWithValue("@Type", 0);
}
else
{
cmd.Parameters.AddWithValue("@Type", 1);
}
//dtDataByfilter1 = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
//dtDataByfilter = new DataTable();
//dtDataByfilter.Load(cmd.ExecuteReader());
//DataTable dt = new DataTable();
//dt = dtDataByfilter;
//==================New Code=============
DataGrid dg = new DataGrid();
dg.DataSource = dt;
dg.DataBind();
// THE EXCEL FILE
string sFileName = "StockLedgerReport" + " - " + System.DateTime.Now.Date + ".xls";
sFileName = sFileName.Replace("/", "");
// SEND OUTPUT TO THE CLIENT MACHINE USING "RESPONSE OBJECT".
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);
Response.ContentType = "application/vnd.ms-excel";
EnableViewState = false;
System.IO.StringWriter objSW = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter objHTW = new System.Web.UI.HtmlTextWriter(objSW);
dg.HeaderStyle.Font.Bold = true; // SET EXCEL HEADERS AS BOLD.
dg.RenderControl(objHTW);
string name = "Stock Ledger Report";
if (rdoDetail.Checked == true)
{
name = name + " - Details";
}
else
{
name = name + " - Summary";
}
string DistributoName = ddlSiteId.SelectedItem.Value + " - " + ddlSiteId.SelectedItem.Text;
Response.Write("<table><tr><td colspan='5' style='width:100px;align-items:center; font:18px;'> <b> " + name + "</b> </td></tr> <tr><td colspan='3'> <b> Distributor Name : " + DistributoName + " </td></tr><tr><td><b>From Date: " + txtFromDate.Text + "</b></td><td></td> <td><b>To Date: " + txtToDate.Text + "</b></td></tr></table>");
// STYLE THE SHEET AND WRITE DATA TO IT.
Response.Write("<style> TABLE { border:dotted 1px #999; } " +
"TD { border:dotted 1px #D5D5D5; text-align:center } </style>");
Response.Write(objSW.ToString());
// ADD A ROW AT THE END OF THE SHEET SHOWING A RUNNING TOTAL OF PRICE.
// Response.Write("<table><tr><td><b>Total: </b></td><td></td><td><b>" +"N2" + "</b></td></tr></table>");
Response.End();
dg = null;
//=================Create Excel==========
//string attachment = "attachment; filename=StockLedgerReport.xls";
//Response.ClearContent();
//Response.AddHeader("content-disposition", attachment);
//Response.ContentType = "application/vnd.ms-excel";
//string tab = "";
//foreach (DataColumn dc in dt.Columns)
//{
// Response.Write(tab + dc.ColumnName);
// tab = "\t";
//}
//Response.Write("\n");
//int i;
//foreach (DataRow dr in dt.Rows)
//{
// tab = "";
// for (i = 0; i < dt.Columns.Count; i++)
// {
// Response.Write(tab + dr[i].ToString());
// tab = "\t";
// }
// Response.Write("\n");
//}
//Response.End();
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void SaveDetails()
{
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
//string Number="DT16000001";
#region getnTUMBER
string Number = string.Empty;
string query = "SELECT ISNULL(MAX(CAST(RIGHT(DISTRUCTION_NO,6) AS INT)),0)+1 FROM [ax].[ACXDISTRUCTIONNOTE] where SITEID='" + Session["SiteCode"].ToString() + "'";
conn = obj.GetConnection();
cmd1 = new SqlCommand(query);
transaction = conn.BeginTransaction();
cmd1.Connection = conn;
cmd1.Transaction = transaction;
cmd1.CommandTimeout = 3600;
cmd1.CommandType = CommandType.Text;
object vc = cmd1.ExecuteScalar();
Number = "DT" + System.DateTime.Today.ToString("yy") + ((int)vc).ToString("000000");
#endregion
#region insert into distruction table
if (Session["SecProductDetails"] != null)
{
//conn = obj.GetConnection();
cmd = new SqlCommand("ACX_INSERTDISTRUCTIONNOTE");
// transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.StoredProcedure;
int i = 0;
foreach (GridViewRow grv in gvDetails.Rows)
{
i = i + 1;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SITEID", Session["SITECODE"].ToString());
if (rdoMarketReturnDistruction.Checked == true)
{
cmd.Parameters.AddWithValue("@CUSTOMERCODE", ddlCustomer.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@CUSTOMERCODE", "");
}
cmd.Parameters.AddWithValue("@DISTRUCTION_NO", Number);
cmd.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString());
cmd.Parameters.AddWithValue("@RECEIPT_NO", "");
cmd.Parameters.AddWithValue("@RECEIPTDATE", "");
cmd.Parameters.AddWithValue("@INVOICE_NO", "");
cmd.Parameters.AddWithValue("@INVOICEDATE", "");
cmd.Parameters.AddWithValue("@LINENO", i);
cmd.Parameters.AddWithValue("@PRODUCTCODE", grv.Cells[1].Text);
cmd.Parameters.AddWithValue("@BOX", grv.Cells[3].Text);
cmd.Parameters.AddWithValue("@BATCHNO", grv.Cells[5].Text.Replace(" ", ""));
cmd.Parameters.AddWithValue("@MFD", grv.Cells[6].Text);
cmd.Parameters.AddWithValue("@REMARK", grv.Cells[7].Text.Replace(" ", ""));
cmd.Parameters.AddWithValue("@PRICE", grv.Cells[8].Text);
cmd.Parameters.AddWithValue("@VALUE", Convert.ToDecimal(grv.Cells[9].Text));
if (rdoMarketReturnDistruction.Checked == true)
{
cmd.Parameters.AddWithValue("@DISTRUCTIONTYPE", 2);
}
else
{
cmd.Parameters.AddWithValue("@DISTRUCTIONTYPE", 1);
}
cmd.ExecuteNonQuery();
}
#endregion
#region insert into transaction table and claim table
cmd2 = new SqlCommand("ACX_DISTRUCTION_STOCK_MOVEMENT");
cmd2.Connection = conn;
cmd2.Transaction = transaction;
cmd2.CommandTimeout = 3600;
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Clear();
cmd2.Parameters.AddWithValue("@Siteid", Session["SITECODE"].ToString());
if (rdoColdRoomDistruction.Checked == true)
{
cmd2.Parameters.AddWithValue("@DISTRUCTIONTYPE", 1);
}
else
{
cmd2.Parameters.AddWithValue("@DISTRUCTIONTYPE", 2);
}
cmd2.Parameters.AddWithValue("@DISTRUCTION_NO", Number);
cmd2.ExecuteNonQuery();
#endregion
transaction.Commit();
ClearAll();
if (rdoMarketReturnDistruction.Checked == true)
{
rdMarketReturnDistruction_CheckedChanged(null, null);
}
string message = "alert('Distruction No : " + Number + " Generated Successfully.!');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true);
}
}
catch (Exception ex)
{
transaction.Rollback();
ErrorSignal.FromCurrentContext().Raise(ex);
string message = "alert('Error:" + ex.Message + " !');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true);
}
finally
{
if (conn != null)
{
if (conn.State.ToString() == "Open")
{
conn.Close();
conn.Dispose();
}
}
}
}
protected void BtnShowReport_Click(object sender, EventArgs e)
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
DataTable dt = new DataTable();
bool b = Validate();
if (b == true)
{
try
{
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
string query = "ACX_USP_SchemeDataReport";
List <string> ilist = new List <string>();
List <string> item = new List <string>();
ilist.Add("@FromDate"); item.Add(txtFromDate.Text);
ilist.Add("@ToDate"); item.Add(txtToDate.Text);
ilist.Add("@SchemeCode");
if (ddlSiteIdNew.SelectedIndex != -1)
{
if (ddlSiteIdNew.SelectedItem.Text != "Select...")
{
item.Add(ddlSiteIdNew.SelectedItem.Value);
}
else
{
item.Add("0");
}
}
else
{
item.Add("0");
}
if (ddlSchemeNew.SelectedIndex == 0)
{
ilist.Add("@SalesType"); item.Add("0");
}
else
{
ilist.Add("@SalesType"); item.Add(ddlSchemeNew.SelectedItem.Text);
}
ilist.Add("@UserCode"); item.Add(ucRoleFilters.GetCommaSepartedSiteId());
// ilist.Add("@DATAAREAID"); item.Add(Session["DATAAREAID"].ToString());
// ilist.Add("@SiteId"); item.Add(Session["USERID"].ToString());
dt = obj.GetData_New(query, CommandType.StoredProcedure, ilist, item);
//if (dt.Rows.Count > 0)
//{
LoadDataInReportViewerDetail(dt);
//}
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
}
void btnRunExceptionWithErrorSignal_Click(object sender, EventArgs e)
{
ltrResponse.Text = "";
ErrorSignal.FromCurrentContext().Raise(new NullReferenceException());
ltrResponse.Text = "Exception set :)";
}
protected void BtnShowReport0_Click(object sender, EventArgs e)
{
try
{
if (txtFromDate.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select the from date!');", true);
return;
}
if (txtFromDate.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select the to date!');", true);
return;
}
if (Convert.ToDateTime(txtFromDate.Text) > (Convert.ToDateTime(txtToDate.Text)))
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please set from date before to date!');", true);
return;
}
bool b = Validate();
if (b)
{
string StateList = "";
strSiteName = "";
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (StateList == "")
{
StateList += "'" + item.Value.ToString() + "'";
strSiteName += "'" + item.Text.ToString() + "'";
}
else
{
StateList += ",'" + item.Value.ToString() + "'";
strSiteName += "'" + item.Text.ToString() + "'";
}
}
}
if (ddlReportType.SelectedValue.ToString() != "0")
{
if (ddlReportType.SelectedValue == "1")
{
ShowData_ForExcel("ACX_USP_VAT_SALETAXREPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "2")
{
ShowData_ForExcel("ACX_USP_VAT_SALETAXSUMMARYREPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "3")
{
ShowData_ForExcel("ACX_USP_CUSTOMERWISE_VAT_REPORT_SALES", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "4")
{
ShowData_ForExcel("ACX_USP_VAT_PURCHASETAXREPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "5")
{
ShowData_ForExcel("ACX_USP_VAT_PURCHASETAX_SUMMARY_REPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "6")
{
ShowData_ForExcel("ACX_USP_VAT_PRODUCTWISEINPUTOUTPUT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "7")
{
ShowData_ForExcel("ACX_USP_VAT_OUTPUTVATREPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "8")
{
ShowData_ForExcel("ACX_USP_VAT_PURCHASEREGISTER_REPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "9")
{
ShowData_ForExcel("ACX_USP_VAT_SALESREGISTER_REPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "10")
{
ShowData_ForExcel("ACX_USP_VAT_ANNEXURE_AB_SALES_REPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "11")
{
ShowData_ForExcel("ACX_USP_VAT_ANNEXURE_AB_PURCHASE_REPORT", ddlReportType.SelectedItem.Text.ToString());
}
if (ddlReportType.SelectedValue == "12")
{
ShowData_ForExcel("ACX_USP_VAT_INPUTVATREPORT", ddlReportType.SelectedItem.Text.ToString());
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select Report Type!');", true);
return;
}
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
try {
if (ddlState.SelectedItem.Text == "All...")
{
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
//DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "Distributor", "DistributorName");
distinctValues.Columns.Add("Name", typeof(string), "Distributor + ' - ' + DistributorName");
ddlSiteId.DataSource = distinctValues;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "Distributor";
ddlSiteId.DataBind();
//ddlSiteId.Items.Add("All...");
ddlSiteId.Items.Insert(0, "All...");
}
else
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ NAME as NAME from [ax].[INVENTSITE] where STATECODE = '" + ddlState.SelectedItem.Value + "'";
ddlSiteId.Items.Insert(0, "All...");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
else
{
ddlSiteId.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
// DataTable dt = (DataTable)Session["SaleHierarchy"];
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
dt.DefaultView.RowFilter = "STATE='" + ddlState.SelectedItem.Value.Trim() + "'";
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
uniqueCols.Columns.Add("Name", typeof(string), "Distributor + ' - ' + DistributorName");
ddlSiteId.DataSource = uniqueCols;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "distributor";
ddlSiteId.DataBind();
ddlSiteId.Items.Insert(0, "All...");
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ NAME as NAME from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
//ddlSiteId.Items.Add("All...");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
}
}
}
catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); }
}
private void LoadDataInReportViewer(DataTable dtSetData)
{
try
{
if (dtSetData.Rows.Count > 0)
{
DataTable DataSetParameter = new DataTable();
DataSetParameter.Columns.Add("FromDate");
DataSetParameter.Columns.Add("ToDate");
DataSetParameter.Columns.Add("StateCode");
DataSetParameter.Columns.Add("Distributor");
DataSetParameter.Columns.Add("UserType");
DataSetParameter.Columns.Add("UserCode");
DataSetParameter.Rows.Add();
DataSetParameter.Rows[0]["FromDate"] = txtFromDate.Text;
DataSetParameter.Rows[0]["ToDate"] = txtToDate.Text;
if (ddlState.SelectedItem.Text == "All...")
{
DataSetParameter.Rows[0]["StateCode"] = "All";
}
else
{
DataSetParameter.Rows[0]["StateCode"] = ddlState.SelectedItem.Text;
}
if (ddlSiteId.SelectedIndex != -1)
{
if (ddlSiteId.SelectedItem.Text == "All...")
{
DataSetParameter.Rows[0]["Distributor"] = "All";
}
else
{
DataSetParameter.Rows[0]["Distributor"] = ddlSiteId.SelectedItem.Text;
}
}
ReportViewer1.AsyncRendering = true;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\SaleRankingReport.rdl");
ReportParameter FromDate = new ReportParameter();
FromDate.Name = "FromDate";
FromDate.Values.Add(txtFromDate.Text);
ReportParameter ToDate = new ReportParameter();
ToDate.Name = "ToDate";
ToDate.Values.Add(txtToDate.Text);
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource RDS1 = new ReportDataSource("DSetData", dtSetData);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource RDS2 = new ReportDataSource("DataSet1", DataSetParameter);
ReportViewer1.LocalReport.DataSources.Add(RDS2);
this.ReportViewer1.LocalReport.Refresh();
ReportViewer1.Visible = true;
LblMessage.Text = String.Empty;
}
else
{
LblMessage.Text = "No Records Exists !!";
ReportViewer1.Visible = false;
}
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void BuildPrintStatusAuditForMenuType(tMenuType menutype, ExcelPackage package, Dictionary <string, int> headerColumns, long cycleId, int classId)
{
try
{
var menuTypeName = menutype.DisplayName;
var worksheet = package.Workbook.Worksheets.Add(menuTypeName);
// Write column headers
foreach (var colKvp in headerColumns)
{
if (colKvp.Value > 0)
{
worksheet.Cells[1, colKvp.Value].Value = colKvp.Key;
worksheet.Cells[1, colKvp.Value].Style.Font.Bold = true;
worksheet.Cells[1, colKvp.Value].AutoFitColumns();
worksheet.Cells[1, colKvp.Value].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[1, colKvp.Value].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[1, colKvp.Value].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
}
}
// Write records
var menus = _menuManagement.GetMenuByCycleClassAndMenutype(cycleId, classId, menutype.ID);
int y = 2;
int rowCount = 0;
foreach (var menu in menus)
{
var menuDetails = _menuManagement.GetMenuById(menu.Id);
var menunameParts = menuDetails.MenuName.Split(new char[] { '/' });
var flights = "";
for (int i = 1; i < menunameParts.Length; i++)
{
flights += menunameParts[i];
if (i != menunameParts.Length - 1)
{
flights += ",";
}
}
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Value = menuDetails.MenuCode;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Value = menunameParts[0];
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Value = flights;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["CurrentStatus"]].Value = menuDetails.ApprovalStatusName;
worksheet.Cells[y + rowCount, headerColumns["CurrentStatus"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["CurrentStatus"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["CurrentStatus"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["CurrentStatus"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
rowCount++;
}
worksheet.Column(1).Width = 15;
worksheet.Column(2).Width = 40;
worksheet.Column(3).Width = 70;
worksheet.Column(4).Width = 25;
}
catch (Exception ex)
{
//write to Elma
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void BuildAuditForMenuType(tMenuType menutype, ExcelPackage package, Dictionary <string, int> headerColumns, long cycleId, int classId)
{
try
{
var menuTypeName = menutype.DisplayName;
var worksheet = package.Workbook.Worksheets.Add(menuTypeName);
// Write column headers
foreach (var colKvp in headerColumns)
{
if (colKvp.Value > 0)
{
worksheet.Cells[1, colKvp.Value].Value = colKvp.Key;
worksheet.Cells[1, colKvp.Value].Style.Font.Bold = true;
worksheet.Cells[1, colKvp.Value].AutoFitColumns();
worksheet.Cells[1, colKvp.Value].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[1, colKvp.Value].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[1, colKvp.Value].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
}
}
// Write records
var menus = _menuManagement.GetMenuByCycleClassAndMenutype(cycleId, classId, menutype.ID);
int y = 2;
int rowCount = 0;
foreach (var menu in menus)
{
var menunameParts = menu.MenuName.Split(new char[] { '/' });
var flights = "";
for (int i = 1; i < menunameParts.Length; i++)
{
flights += menunameParts[i];
if (i != menunameParts.Length - 1)
{
flights += ",";
}
}
var menuHistory = _menuManagement.GetMenuHistory(menu.Id);
if (menuHistory == null)
{
continue;
}
foreach (var history in menuHistory)
{
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Value = menu.MenuCode;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuCode"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Value = menunameParts[0];
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["MenuName"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Value = flights;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["Flights"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["ActionTaken"]].Value = history.ActionTaken;
worksheet.Cells[y + rowCount, headerColumns["ActionTaken"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["ActionTaken"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ActionTaken"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ActionTaken"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
worksheet.Cells[y + rowCount, headerColumns["ModifiedAt"]].Value = Convert.ToDateTime(history.ModifiedAt).ToShortDateString();
worksheet.Cells[y + rowCount, headerColumns["ModifiedAt"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["ModifiedAt"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ModifiedAt"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ModifiedAt"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
var user = _accountManagement.GetUserById(Convert.ToInt32(history.ActionByUserID));
worksheet.Cells[y + rowCount, headerColumns["ActionByUser"]].Value = user.FirstName + " " + user.LastName;
worksheet.Cells[y + rowCount, headerColumns["ActionByUser"]].Style.WrapText = true;
worksheet.Cells[y + rowCount, headerColumns["ActionByUser"]].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ActionByUser"]].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
worksheet.Cells[y + rowCount, headerColumns["ActionByUser"]].Style.Border.BorderAround(
OfficeOpenXml.Style.ExcelBorderStyle.Thin, System.Drawing.Color.Black);
rowCount++;
}
}
worksheet.Column(1).Width = 15;
worksheet.Column(2).Width = 40;
worksheet.Column(3).Width = 70;
worksheet.Column(4).Width = 25;
worksheet.Column(5).Width = 35;
worksheet.Column(6).Width = 25;
}
catch (Exception ex)
{
//write to Elma
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void LoadDataInReportViewer(DataTable dtSetData)
{
try
{
if (dtSetData.Rows.Count > 0)
{
DataTable DataSetParameter = new DataTable();
DataSetParameter.Columns.Add("FromDate");
DataSetParameter.Columns.Add("ToDate");
DataSetParameter.Columns.Add("STATECODE");
DataSetParameter.Columns.Add("SiteId");
DataSetParameter.Columns.Add("CUSTOMER_CODE");
DataSetParameter.Rows.Add();
DataSetParameter.Rows[0]["FromDate"] = txtFromDate.Text;
DataSetParameter.Rows[0]["ToDate"] = txtToDate.Text;
string ListState = "";
string DistributorList = "";
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
ListState = ucRoleFilters.GetCommaSepartedStateId();
DistributorList = ucRoleFilters.GetCommaSepartedSiteId();
}
else
{
foreach (ListItem item in chkListState.Items)
{
if (item.Selected)
{
if (ListState == "")
{
ListState += "" + item.Text.ToString() + "";
}
else
{
ListState += "," + item.Text.ToString() + "";
}
}
}
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (DistributorList == "")
{
DistributorList += "" + item.Text.ToString() + "";
}
else
{
DistributorList += "," + item.Text.ToString() + "";
}
}
}
}
DataSetParameter.Rows[0]["STATECODE"] = ListState;
if (DistributorList == string.Empty)
{
DistributorList = "ALL";
}
DataSetParameter.Rows[0]["SiteId"] = DistributorList;
string CustomerGroupList = "";
foreach (ListItem item in chkListCustomerGroup.Items)
{
if (item.Selected)
{
if (CustomerGroupList == "")
{
CustomerGroupList += "" + item.Text.ToString() + "";
}
else
{
CustomerGroupList += "," + item.Text.ToString() + "";
}
}
}
if (CustomerGroupList == string.Empty)
{
CustomerGroupList = "ALL";
}
DataSetParameter.Rows[0]["CUSTOMER_CODE"] = CustomerGroupList;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\DiscountOutletSchemeReport.rdl");
ReportParameter FromDate = new ReportParameter();
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.AsyncRendering = true;
ReportDataSource RDS1 = new ReportDataSource("DataSet1", dtSetData);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource RDS2 = new ReportDataSource("DataSet2", DataSetParameter);
ReportViewer1.LocalReport.DataSources.Add(RDS2);
this.ReportViewer1.LocalReport.Refresh();
ReportViewer1.Visible = true;
LblMessage.Text = String.Empty;
}
else
{
LblMessage.Text = "No Records Exists !!";
ReportViewer1.Visible = false;
}
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
public void GeneratePrintStausAudit(long cycleId, int classId, int menuTypeId)
{
try
{
var cycle = _cycleManagement.GetCycle(cycleId);
// Set up columns
var headerColumns = BuilderPrintStatusAuditHeader();
var className = _menuManagement.GetClassShortName(classId);
if (menuTypeId == -1)
{
//all the menu - show each menu type as worksheet tab
using (var package = new ExcelPackage())
{
var menuTypes = _menuManagement.GetMenuTypeByClass(classId);
foreach (var menutype in menuTypes)
{
BuildPrintStatusAuditForMenuType(menutype, package, headerColumns, cycleId, classId);
}
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\PrintStatusReport\" + cycle.CycleName + "_" + className + "_PrintStatus.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
else
{
using (var package = new ExcelPackage())
{
var menuType = _menuManagement.GetMenuTypeById(menuTypeId);
BuildPrintStatusAuditForMenuType(menuType, package, headerColumns, cycleId, classId);
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\PrintStatusReport\" + cycle.CycleName + "_" + className + "_" + menuType.DisplayName + "_PrintStatus.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
}
catch (Exception ex)
{
//write to Elma
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new Global();
SqlConnection conn = null;
SqlCommand cmd = null;
DataTable dtDataByfilter = null;
string query = string.Empty;
try
{
conn = new SqlConnection(objGlobal.GetConnectionString());
// conn.Open();
cmd = new SqlCommand();
// cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
query = "[ax].[ACX_DiscountOutletSchemeReport]";
cmd.CommandText = query;
//DateTime lastDay = new DateTime(now.Year, now.Month, 1);
cmd.Parameters.AddWithValue("@FromDate", Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyy"));
cmd.Parameters.AddWithValue("@ToDate", Convert.ToDateTime(txtToDate.Text).ToString("dd-MMM-yyy"));
string ListState = "";
string DistributorList = "";
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
ListState = ucRoleFilters.GetCommaSepartedStateId();
DistributorList = ucRoleFilters.GetCommaSepartedSiteId();
}
else
{
foreach (ListItem item in chkListState.Items)
{
if (item.Selected)
{
if (ListState == "")
{
ListState += "" + item.Value.ToString() + "";
}
else
{
ListState += "," + item.Value.ToString() + "";
}
}
}
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (DistributorList == "")
{
DistributorList += "" + item.Value.ToString() + "";
}
else
{
DistributorList += "," + item.Value.ToString() + "";
}
}
}
}
if (ListState.Length > 0)
{
cmd.Parameters.AddWithValue("@STATECODE", ListState);
}
else
{
cmd.Parameters.AddWithValue("@STATECODE", "");
}
if (DistributorList.Length > 0)
{
cmd.Parameters.AddWithValue("@SiteId", DistributorList);
}
else
{
cmd.Parameters.AddWithValue("@SiteId", "");
}
string CustGroupList = "";
foreach (ListItem item in chkListCustomerGroup.Items)
{
if (item.Selected)
{
if (CustGroupList == "")
{
CustGroupList += "" + item.Value.ToString() + "";
}
else
{
CustGroupList += "," + item.Value.ToString() + "";
}
}
}
if (CustGroupList.Length > 0)
{
cmd.Parameters.AddWithValue("@CUSTOMER_CODE", CustGroupList);
}
else
{
cmd.Parameters.AddWithValue("@CUSTOMER_CODE", "");
}
dtDataByfilter = new DataTable();
cmd.Connection = objGlobal.GetConnection();
dtDataByfilter.Load(cmd.ExecuteReader());
LoadDataInReportViewer(dtDataByfilter);
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
objGlobal.CloseSqlConnection();
}
}
public void Log(Exception exception)
{
Trace.TraceError(exception.ToString());
ErrorSignal.FromCurrentContext().Raise(exception);
}
// This method is auto-detected by the OWIN pipeline. DO NOT RENAME IT!
public static void Configuration(IAppBuilder app)
{
// Tune ServicePointManager
// (based on http://social.technet.microsoft.com/Forums/en-US/windowsazuredata/thread/d84ba34b-b0e0-4961-a167-bbe7618beb83 and https://msdn.microsoft.com/en-us/library/system.net.servicepointmanager.aspx)
ServicePointManager.DefaultConnectionLimit = 500;
ServicePointManager.UseNagleAlgorithm = false;
ServicePointManager.Expect100Continue = false;
// Register IoC
app.UseAutofacInjection(GlobalConfiguration.Configuration);
var dependencyResolver = DependencyResolver.Current;
// Register Elmah
var elmahServiceCenter = new DependencyResolverServiceProviderAdapter(dependencyResolver);
ServiceCenter.Current = _ => elmahServiceCenter;
// Get config
var config = dependencyResolver.GetService <IGalleryConfigurationService>();
var auth = dependencyResolver.GetService <AuthenticationService>();
// Setup telemetry
var instrumentationKey = config.Current.AppInsightsInstrumentationKey;
if (!string.IsNullOrEmpty(instrumentationKey))
{
TelemetryConfiguration.Active.InstrumentationKey = instrumentationKey;
// Add enrichers
TelemetryConfiguration.Active.TelemetryInitializers.Add(new ClientInformationTelemetryEnricher());
var telemetryProcessorChainBuilder = TelemetryConfiguration.Active.TelemetryProcessorChainBuilder;
// Add processors
telemetryProcessorChainBuilder.Use(next =>
{
var processor = new RequestTelemetryProcessor(next);
processor.SuccessfulResponseCodes.Add(400);
processor.SuccessfulResponseCodes.Add(404);
return(processor);
});
telemetryProcessorChainBuilder.Use(
next => new ExceptionTelemetryProcessor(next, Telemetry.TelemetryClient));
// Note: sampling rate must be a factor 100/N where N is a whole number
// e.g.: 50 (= 100/2), 33.33 (= 100/3), 25 (= 100/4), ...
// https://azure.microsoft.com/en-us/documentation/articles/app-insights-sampling/
var instrumentationSamplingPercentage = config.Current.AppInsightsSamplingPercentage;
if (instrumentationSamplingPercentage > 0 && instrumentationSamplingPercentage < 100)
{
telemetryProcessorChainBuilder.UseSampling(instrumentationSamplingPercentage);
}
telemetryProcessorChainBuilder.Build();
}
// Configure logging
app.SetLoggerFactory(new DiagnosticsLoggerFactory());
// Remove X-AspNetMvc-Version header
MvcHandler.DisableMvcResponseHeader = true;
if (config.Current.RequireSSL)
{
// Put a middleware at the top of the stack to force the user over to SSL
if (string.IsNullOrWhiteSpace(config.Current.ForceSslExclusion))
{
app.UseForceSsl(config.Current.SSLPort);
}
else
{
app.UseForceSsl(config.Current.SSLPort, new[] { config.Current.ForceSslExclusion });
}
}
// Get the local user auth provider, if present and attach it first
Authenticator localUserAuthenticator;
if (auth.Authenticators.TryGetValue(Authenticator.GetName(typeof(LocalUserAuthenticator)), out localUserAuthenticator))
{
// Configure cookie auth now
localUserAuthenticator.Startup(config, app).Wait();
}
// Attach external sign-in cookie middleware
app.SetDefaultSignInAsAuthenticationType(AuthenticationTypes.External);
app.UseCookieAuthentication(new CookieAuthenticationOptions
{
AuthenticationType = AuthenticationTypes.External,
AuthenticationMode = AuthenticationMode.Passive,
CookieName = ".AspNet." + AuthenticationTypes.External,
ExpireTimeSpan = TimeSpan.FromMinutes(5)
});
// Attach non-cookie auth providers
var nonCookieAuthers = auth
.Authenticators
.Where(p => !String.Equals(
p.Key,
Authenticator.GetName(typeof(LocalUserAuthenticator)),
StringComparison.OrdinalIgnoreCase))
.Select(p => p.Value);
foreach (var auther in nonCookieAuthers)
{
auther.Startup(config, app).Wait();
}
// Catch unobserved exceptions from threads before they cause IIS to crash:
TaskScheduler.UnobservedTaskException += (sender, exArgs) =>
{
// Send to AppInsights
try
{
var telemetryClient = new TelemetryClient();
telemetryClient.TrackException(exArgs.Exception, new Dictionary <string, string>()
{
{ "ExceptionOrigin", "UnobservedTaskException" }
});
}
catch (Exception)
{
// this is a tragic moment... swallow Exception to prevent crashing IIS
}
// Send to ELMAH
try
{
HttpContext current = HttpContext.Current;
if (current != null)
{
var errorSignal = ErrorSignal.FromContext(current);
if (errorSignal != null)
{
errorSignal.Raise(exArgs.Exception, current);
}
}
}
catch (Exception)
{
// more tragedy... swallow Exception to prevent crashing IIS
}
exArgs.SetObserved();
};
HasRun = true;
}
private void ShowRecords(string ReceiptNumber, string DistCode)
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
DataTable dtHeader = null;
DataTable dtLine = null;
try
{
string queryHeader = " Select A.CUSTOMER_CODE, A.INVOICE_NO, A.SO_NO, A.SO_DATE, A.INVOICE_VALUE, A.INVOIC_DATE, A.TRANSPORTER_CODE, A.VEHICAL_NO, " +
" A.DRIVER_CODE, A.DRIVER_MOBILENO, A.SITEID AS DISTRIBUTORCODE, B.SITEID, B.NAME AS DISTRIBUTORNAME,a.DISTGSTINNO,A.DISTGSTINREGDATE,A.DISTCOMPOSITIONSCHEME from ax.[ACXSALEINVOICEHEADER] A INNER JOIN" +
" ax.inventsite B on A.SITEID=B.SITEID where A.INVOICE_NO='" + ReceiptNumber + "' " +
" and A.CUSTOMER_CODE='" + Session["SiteCode"].ToString() + "' and A.SITEID='" + DistCode + "' AND A.INVOICE_NO NOT IN (SELECT Sale_InvoiceNo FROM AX.ACXPURCHINVRECIEPTHEADER WHERE Site_Code='" + Session["SiteCode"].ToString() + "' AND Supplier_Code ='" + DistCode + "')";
string queryLine = " Select SIL.LINE_NO, SIL.PRODUCT_CODE, (PRODUCT_CODE+'-'+ PRODUCT_NAME) AS PRODUCTDESC, SIL.BOX, SIL.CRATES, SIL.LTR, " +
" QUANTITY,SIL.MRP, SIL.RATE, INVT.UOM, TAX_CODE, TAX_AMOUNT, DISC_AMOUNT, ADDTAX_CODE, ADDTAX_AMOUNT, " +
" TDValue SEC_DISC_AMOUNT, LINEAMOUNT, AMOUNT,SIL.HSNCODE,SIL.COMPOSITIONSCHEME,SIL.TAXCOMPONENT,SIL.ADDTAXCOMPONENT from [ax].[ACXSALEINVOICELINE] SIL INNER JOIN AX.INVENTTABLE INVT " +
" ON SIL.PRODUCT_CODE = INVT.ITEMID where SIL.INVOICE_NO='" + ReceiptNumber + "' and SIL.CUSTOMER_CODE='" + Session["SiteCode"].ToString() + "' and SIL.SITEID='" + DistCode + "' AND SIL.INVOICE_NO NOT IN (SELECT Sale_InvoiceNo FROM AX.ACXPURCHINVRECIEPTHEADER WHERE Site_Code='" + Session["SiteCode"].ToString() + "' AND Supplier_Code ='" + DistCode + "')";
dtHeader = obj.GetData(queryHeader);
if (dtHeader.Rows.Count == 0 || dtHeader == null)
{
return;
}
txtIndentNo.Text = string.Empty;
txtIndentDate.Text = string.Empty;
txtTransporterName.Text = dtHeader.Rows[0]["TRANSPORTER_CODE"].ToString();
txtvehicleNo.Text = dtHeader.Rows[0]["VEHICAL_NO"].ToString();
txtcomposition.Text = dtHeader.Rows[0]["DISTCOMPOSITIONSCHEME"].ToString();
txtGstno.Text = dtHeader.Rows[0]["DISTGSTINNO"].ToString();
txtRegistrationdate.Text = dtHeader.Rows[0]["DISTGSTINREGDATE"].ToString();
DateTime ReceiptDate = Convert.ToDateTime(dtHeader.Rows[0]["INVOIC_DATE"].ToString());
txtReceiptDate.Text = ReceiptDate.ToString("dd-MMM-yyyy");
txtInvoiceNo.Text = dtHeader.Rows[0]["INVOICE_NO"].ToString();
txtSONo.Text = dtHeader.Rows[0]["SO_NO"].ToString();
if (txtSONo.Text != string.Empty)
{
LoadIndent(txtSONo.Text.Trim().ToString());
}
txttransporterNo.Text = dtHeader.Rows[0]["DRIVER_CODE"].ToString();
txtVehicleType.Text = string.Empty;
decimal RecptValue = Convert.ToDecimal(dtHeader.Rows[0]["INVOICE_VALUE"].ToString());
txtReceiptValue.Text = (Math.Round(RecptValue, 2)).ToString();
txtDistributorCode.Text = dtHeader.Rows[0]["DISTRIBUTORCODE"].ToString();
txtDistributorName.Text = dtHeader.Rows[0]["DISTRIBUTORNAME"].ToString();
List <string> ilist = new List <string>();
List <string> litem = new List <string>();
ilist.Add("@INVOICENO"); litem.Add(ReceiptNumber);
ilist.Add("@SITEID"); litem.Add(Session["SiteCode"].ToString());
ilist.Add("@DISTRIBUTOR"); litem.Add(DistCode);
dtLine = obj.GetData_New("USP_GETPENDING_PURCHRECEIPTLINE", CommandType.StoredProcedure, ilist, litem);
//dtLine = obj.GetData(queryLine);
Session[SessionGrid] = dtLine;
if (dtLine.Rows.Count > 0)
{
GridPurchItems.DataSource = dtLine;
GridPurchItems.DataBind();
GridPurchItems.Visible = true;
GridViewFooterTotalShow(dtLine);
}
else
{
LblMessage.Text = "No Line Items Exist";
}
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
public void GenerateAuditTrail(long cycleId, int classId, int menuTypeId, string departure, string arrival)
{
try
{
var cycle = _cycleManagement.GetCycle(cycleId);
// Set up columns
var headerColumns = BuilderAuditHeader();
var className = _menuManagement.GetClassShortName(classId);
if (menuTypeId == -1)
{
//all the menu - show each menu type as worksheet tab
if (arrival == "All" && departure == "All")
{
using (var package = new ExcelPackage())
{
var menuTypes = _menuManagement.GetMenuTypeByClass(classId);
foreach (var menutype in menuTypes)
{
BuildAuditForMenuType(menutype, package, headerColumns, cycleId, classId);
}
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\Audit\" + cycle.CycleName + "_" + className + "_Audit_AllRoutes.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
else
{
//rotue specific
if (arrival != "All" && departure != "All")
{
var routeId = _routeManagement.GetRouteId(departure, arrival);
using (var package = new ExcelPackage())
{
var menuTypes = _menuManagement.GetMenuTypeByClass(classId);
foreach (var menutype in menuTypes)
{
BuildAuditForMenuTypeRouteBased(menutype, package, headerColumns, cycleId, classId, routeId);
}
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\Audit\" + cycle.CycleName + "_" + className + "_" + departure + "_" + arrival + "_Audit.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
else
{
//handle route where one location is all
}
}
}
else
{
if (arrival == "All" && departure == "All")
{
using (var package = new ExcelPackage())
{
var menuType = _menuManagement.GetMenuTypeById(menuTypeId);
BuildAuditForMenuType(menuType, package, headerColumns, cycleId, classId);
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\Audit\" + cycle.CycleName + "_" + className + "_" + menuType.DisplayName + "_Audit_AllRoutes.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
else
{
//rotue specific
if (arrival != "All" && departure != "All")
{
var routeId = _routeManagement.GetRouteId(departure, arrival);
using (var package = new ExcelPackage())
{
var menuType = _menuManagement.GetMenuTypeById(menuTypeId);
BuildAuditForMenuTypeRouteBased(menuType, package, headerColumns, cycleId, classId, routeId);
// Save file and return stream
var fileName = Path.GetTempFileName();
package.SaveAs(new FileInfo(fileName));
var stream = new FileStream(fileName, FileMode.Open);
var directory = Directory.GetParent(HttpRuntime.AppDomainAppPath);
var parentDir = directory.Parent;
var path = parentDir.FullName + @"\Audit\" + cycle.CycleName + "_" + className + "_" + menuType.DisplayName + "_" + departure + "_" + arrival + "_Audit.xlsx";
Helper.SaveStreamToFile(path, stream);
}
}
else
{
//handle route where one location is all
}
}
}
}
catch (Exception ex)
{
//write to Elma
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new CreamBell_DMS_WebApps.App_Code.Global();
SqlConnection conn = null;
SqlCommand cmd = null;
DataTable dtDataByfilter = null;
string query = string.Empty;
try
{
conn = new SqlConnection(objGlobal.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
query = "ACX_USP_DEEPFREZEERSALESREPORT";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@STARTDATE", Convert.ToDateTime(txtFromDate.Text));
cmd.Parameters.AddWithValue("@ENDDATE", Convert.ToDateTime(txtToDate.Text));
cmd.Parameters.AddWithValue("@UserType", Convert.ToString(Session["LOGINTYPE"]));
cmd.Parameters.AddWithValue("@UserCode", Convert.ToString(Session["USERID"]));
if (ddlState.SelectedIndex > 0 || ddlState.SelectedItem.Text != "All...")
{
cmd.Parameters.AddWithValue("@StateCode", ddlState.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@StateCode", "");
}
// site
if (ddlSiteId.SelectedIndex < 0)
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
foreach (DataRow row in dt.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
}
else
{
cmd.Parameters.AddWithValue("@SiteId", "");
}
}
else if (ddlSiteId.SelectedIndex > 0)
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else if (ddlSiteId.SelectedItem.Text != "All...")
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
DataView view = new DataView(dt);
if (ddlState.SelectedItem.Text != "All...")
{
view.RowFilter = "STATE='" + ddlState.SelectedItem.Value.Trim() + "'";
}
DataTable uniqueCols = view.ToTable(true, "Distributor", "DistributorName");
foreach (DataRow row in uniqueCols.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
cmd.Parameters.AddWithValue("@SiteId", siteid);
}
else
{
cmd.Parameters.AddWithValue("@SiteId", "");
}
}
if (drpCategory.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@Category", drpCategory.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@Category", "");
}
if (drpSubCategory.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@SubCategory", drpSubCategory.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@SubCategory", "");
}
if (drpProduct.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@Product", drpProduct.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@Product", "");
}
if (drpCustGroup.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@CustGroup", drpCustGroup.SelectedItem.Value);
}
else
{
cmd.Parameters.AddWithValue("@CustGroup", "");
}
dtDataByfilter = new DataTable();
dtDataByfilter.Load(cmd.ExecuteReader());
if (dtDataByfilter.Rows.Count > 0)
{
//=================Create Excel==========
string attachment = "attachment; filename=DEEPFREZEERREPORT.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dtDataByfilter.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dtDataByfilter.Rows)
{
tab = "";
for (i = 0; i < dtDataByfilter.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.Flush();
Response.SuppressContent = true;
}
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (conn != null)
{
if (conn.State.ToString() == "Open")
{
conn.Close();
}
}
}
}
public void LogException(Exception exc)
{
ErrorSignal.FromCurrentContext().Raise(exc);
}
private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new CreamBell_DMS_WebApps.App_Code.Global();
SqlConnection conn = null;
SqlCommand cmd = null;
DataTable dtDataByfilter = null;
string query = string.Empty;
try
{
conn = new SqlConnection(objGlobal.GetConnectionString());
// conn.Open();
cmd = new SqlCommand();
// cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
query = "[dbo].[ACX_USP_SALERANKINGREPORT]";
cmd.CommandText = query;
DateTime now = Convert.ToDateTime(txtToDate.Text);
now = now.AddMonths(1);
//DateTime lastDay = new DateTime(now.Year, now.Month, 1);
cmd.Parameters.AddWithValue("@STARTDATE", Convert.ToDateTime(txtFromDate.Text));
cmd.Parameters.AddWithValue("@ENDDATE", Convert.ToDateTime(txtToDate.Text));
cmd.Parameters.AddWithValue("@UserType", Convert.ToString(Session["LOGINTYPE"]));
cmd.Parameters.AddWithValue("@UserCode", Convert.ToString(Session["USERID"]));
if (drpCustGroup.SelectedItem.Text == "All...")
{
cmd.Parameters.AddWithValue("@CustGroup", "");
}
else
{
cmd.Parameters.AddWithValue("@CustGroup", drpCustGroup.SelectedItem.Value.ToString());
}
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value.ToString());
//if (ddlSiteId.SelectedIndex >= 1)
//{
// cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
//}
//else
//{
// cmd.Parameters.AddWithValue("@SiteId", " ");
//}
if (ddlSiteId.SelectedIndex < 0)
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
foreach (DataRow row in dt.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
}
}
else if (ddlSiteId.SelectedIndex > 0)
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else if (ddlSiteId.SelectedItem.Text != "All...")
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
foreach (DataRow row in dt.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
cmd.Parameters.AddWithValue("@SiteId", siteid);
}
else
{
cmd.Parameters.AddWithValue("@SiteId", "");
}
}
if (DDLBusinessUnit.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@BUCODE", DDLBusinessUnit.SelectedItem.Value.ToString());
}
else
{
cmd.Parameters.AddWithValue("@BUCODE", "");
}
dtDataByfilter = new DataTable();
cmd.Connection = objGlobal.GetConnection();
dtDataByfilter.Load(cmd.ExecuteReader());
LoadDataInReportViewer(dtDataByfilter);
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
objGlobal.CloseSqlConnection();
}
}
public void ReadXml(XmlReader reader)
{
var s = reader.ReadOuterXml();
var x = XDocument.Parse(s);
if (x.Root == null)
{
return;
}
eqset = 0;
txset = 0;
menuset = 0;
foreach (var e in x.Root.Elements())
{
var name = e.Name.ToString();
switch (name)
{
case "FundItem":
ReadFundItem(e);
break;
case "FamilyAttend":
ReadFamilyAttend(e);
break;
case "ExtraQuestion":
ReadExtraQuestion(e);
break;
case "Text":
ReadText(e);
break;
case "YesNoQuestion":
ReadYesNoChoices(e);
break;
case "option":
ReadDropdownOption(e);
break;
case "Checkbox":
ReadCheckboxChoice(e);
break;
case "MenuItem":
ReadMenuItemChoice(e);
break;
case "MissionTripGoerId":
MissionTripGoerId = e.Value.ToInt();
break;
case "CreatingAccount":
CreatingAccount = e.Value.ToBool();
break;
case "SpecialTest":
ReadSpecialTest(e);
break;
default:
if (Util.SetPropertyFromText(this, TranslateName(name), e.Value) == false)
{
ErrorSignal.FromCurrentContext().Raise(new Exception("OnlineRegPerson Missing name:" + name));
Log($"Error:Missing({name})");
}
break;
}
}
}
public ActionResult Edit([Bind(Include = "id,FirstName,LastName,shortname,Wheelchair,rowversion")] Membership membership)
{
try
{
if (ModelState.IsValid)
{
_db.Entry(membership).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var clientValues = (Membership)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
ModelState.AddModelError(string.Empty,
"Unable to save changes. The member was deleted by another user.");
}
else
{
var databaseValues = (Membership)databaseEntry.ToObject();
if (databaseValues.FirstName != clientValues.FirstName)
{
ModelState.AddModelError("First Name", "Current value: "
+ databaseValues.FirstName);
}
if (databaseValues.LastName != clientValues.LastName)
{
ModelState.AddModelError("Last Name", "Current value: "
+ databaseValues.LastName);
}
if (databaseValues.shortname != clientValues.shortname)
{
ModelState.AddModelError("Short Name", "Current value: "
+ databaseValues.shortname);
}
if (databaseValues.Wheelchair != clientValues.Wheelchair)
{
ModelState.AddModelError("Wheelchair", "Current value: "
+ databaseValues.Wheelchair);
}
ModelState.AddModelError(string.Empty, "The record you attempted to edit "
+ "was modified by another user after you got the original value. The "
+ "edit operation was canceled and the current values in the database "
+ "have been displayed. If you still want to edit this record, click "
+ "the Save button again. Otherwise click the Back to List hyperlink.");
membership.rowversion = databaseValues.rowversion;
}
}
catch (DbUpdateException)
{
ModelState.AddModelError("",
"Unable to save changes. Cannot have duplicate names.");
}
catch (Exception dex)
{
//Log the error (uncomment dex variable name and add a line here to write a log.)
ModelState.AddModelError("",
"Unable to save changes. Try again, and if the problem persists, see your system administrator.");
ErrorSignal.FromCurrentContext().Raise(dex);
}
return(View(membership));
}
public RouteModel ProcessPayment(ModelStateDictionary modelState, OnlineRegModel m)
{
if (m != null && m.email.HasValue() && !Util.ValidEmail(m.email))
{
modelState.AddModelError("form", "Invalid email address");
return(RouteModel.Invalid("Payment/Process", "Invalid email address"));
}
PreventNegatives();
PreventZero(modelState);
if (!modelState.IsValid)
{
return(RouteModel.ProcessPayment());
}
try
{
PreventNegatives();
PreventZero(modelState);
if (!modelState.IsValid)
{
return(RouteModel.ProcessPayment());
}
ValidatePaymentForm(modelState);
if (!modelState.IsValid)
{
return(RouteModel.ProcessPayment());
}
if (m?.UserPeopleId != null && m.UserPeopleId > 0)
{
CheckStoreInVault(modelState, m.UserPeopleId.Value);
}
if (!modelState.IsValid)
{
return(RouteModel.ProcessPayment());
}
var ti = ProcessPaymentTransaction(m);
if (ti.Approved == false)
{
modelState.AddModelError("form", ti.Message);
return(RouteModel.ProcessPayment());
}
HttpContextFactory.Current.Session["FormId"] = FormId;
if (m != null)
{
m.DatumId = DatumId; // todo: not sure this is necessary
return(m.FinishRegistration(ti));
}
OnlineRegModel.ConfirmDuePaidTransaction(ti, ti.TransactionId, true);
return(RouteModel.AmountDue(AmountDueTrans(DbUtil.Db, ti), ti));
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
modelState.AddModelError("form", ex.Message);
return(RouteModel.ProcessPayment());
}
}
public ActionResult OnePageGiving(PaymentForm pf, Dictionary <int, decimal?> fundItem)
{
// need save off the original amt to pay if there is an error later on.
var amtToPay = pf.AmtToPay;
var id = pf.OrgId;
if (id == null)
{
return(Message("Missing OrgId"));
}
if (!Util.ValidEmail(pf.Email))
{
ModelState.AddModelError("Email", "Need a valid email address");
}
if (pf.IsUs && !pf.Zip.HasValue())
{
ModelState.AddModelError("Zip", "Zip is Required for US");
}
if (pf.ShowCampusOnePageGiving)
{
if ((pf.CampusId ?? 0) == 0)
{
ModelState.AddModelError("CampusId", "Campus is Required");
}
}
var m = new OnlineRegModel(Request, CurrentDatabase, pf.OrgId, pf.testing, null, null, pf.source)
{
URL = $"/OnePageGiving/{pf.OrgId}"
};
m.ProcessType = pf.ProcessType;
var pid = CurrentDatabase.UserPeopleId;
if (pid.HasValue)
{
PrePopulate(m, pid.Value);
}
// we need to always retrieve the entire list of funds for one page giving calculations.
m.List[0].RetrieveEntireFundList = true;
// first re-build list of fund items with only ones that contain a value (amt).
var fundItems = fundItem.Where(f => f.Value.GetValueOrDefault() > 0).ToDictionary(f => f.Key, f => f.Value);
var designatedFund = m.settings[id.Value].DonationFundId ?? 0;
if (designatedFund != 0)
{
fundItems.Add(designatedFund, pf.AmtToPay);
}
// set the fund items on online reg person if there are any.
if (fundItems.Any())
{
m.List[0].FundItem = fundItems;
pf.AmtToPay = m.List[0].FundItemsChosen().Sum(f => f.Amt);
}
if (pf.AmtToPay.GetValueOrDefault() == 0)
{
ModelState.AddModelError("AmtToPay", "Invalid Amount");
}
SetHeaders(m);
SetInstructions(m);
var p = m.List[0];
if (pf.ShowCampusOnePageGiving)
{
pf.Campuses = p.Campuses().ToList();
}
if (!ModelState.IsValid)
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if (CheckAddress(pf) == false)
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if (!ModelState.IsValid)
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
p.orgid = m.Orgid;
p.FirstName = pf.First;
p.LastName = pf.Last;
p.EmailAddress = pf.Email;
p.Phone = pf.Phone;
p.AddressLineOne = pf.Address;
p.City = pf.City;
p.State = pf.State;
p.ZipCode = pf.Zip;
p.Country = pf.Country;
p.ProcessType = pf.ProcessType;
if (pf.ShowCampusOnePageGiving)
{
p.Campus = pf.CampusId.ToString();
}
p.IsNew = p.person == null;
if (pf.testing)
{
pf.CheckTesting();
}
if (pf.Country.HasValue() && !pf.Zip.HasValue())
{
pf.Zip = "NA";
}
pf.ValidatePaymentForm(ModelState, false);
if (!ModelState.IsValid)
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if (m?.UserPeopleId != null && m.UserPeopleId > 0)
{
try
{
pf.CheckStoreInVault(ModelState, m.UserPeopleId.Value);
}
catch (Exception ex)
{
if (ex.Message == "InvalidVaultId")
{
ClearPaymentInfo(ModelState, pf);
}
}
}
if (!ModelState.IsValid)
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if (CurrentDatabase.Setting("UseRecaptcha"))
{
if (!GoogleRecaptcha.IsValidResponse(HttpContext, CurrentDatabase))
{
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
ModelState.AddModelError("TranId", "ReCaptcha validation failed.");
return(View("OnePageGiving/Index", new OnePageGivingModel {
OnlineRegPersonModel = m.List[0],
PaymentForm = pf
}));
}
}
var ti = pf.ProcessPaymentTransaction(m);
if (ti == null)
{
ModelState.AddModelError("TranId", "Transaction duplicated");
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if ((ti.Approved ?? false) == false)
{
ModelState.AddModelError("TranId", ti.Message);
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
}
if (pf.Zip == "NA")
{
pf.Zip = null;
}
var ret = m.ConfirmTransaction(ti);
RequestManager.SessionProvider.Clear();
switch (ret.Route)
{
case RouteType.ModelAction:
if (ti.Approved == true)
{
var url = $"/OnePageGiving/ThankYou/{id}{(pf.testing ? $"?testing=true&source={pf.source}" : $"?source={pf.source}")}";
return(Redirect(url));
}
ErrorSignal.FromCurrentContext().Raise(new Exception(ti.Message));
ModelState.AddModelError("TranId", ti.Message);
m.List[0].FundItem = fundItem;
pf.AmtToPay = amtToPay;
return(View("OnePageGiving/Index", new OnePageGivingModel()
{
OnlineRegPersonModel = m.List[0], PaymentForm = pf
}));
private void GridViewFooterTotalShow(DataTable dt)
{
try
{
decimal Box = dt.AsEnumerable().Sum(row => row.Field <decimal>("BOX")); //For Total[Sum] Box Show in Footer--//
GridPurchItems.FooterRow.Cells[4].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[4].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[4].Text = "Box: " + Box.ToString("N2");
GridPurchItems.FooterRow.Cells[4].Font.Bold = true;
decimal Crate = dt.AsEnumerable().Sum(row => row.Field <decimal>("CRATES")); //For Total[Sum] Show in Footer--//
GridPurchItems.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[5].Text = "Crate: " + Crate.ToString("N2");
GridPurchItems.FooterRow.Cells[5].Font.Bold = true;
decimal Litre = dt.AsEnumerable().Sum(row => row.Field <decimal>("LTR")); //For Total[Sum] Litre Show in Footer--//
GridPurchItems.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[6].Text = "Ltr: " + Litre.ToString("N2");
GridPurchItems.FooterRow.Cells[6].Font.Bold = true;
decimal Rate = dt.AsEnumerable().Sum(row => row.Field <decimal>("RATE")); //For Total[Sum] Show in Footer--//
GridPurchItems.FooterRow.Cells[8].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[8].Text = "Rate: " + Rate.ToString("N2");
GridPurchItems.FooterRow.Cells[8].Font.Bold = true;
decimal TaxAmount = dt.AsEnumerable().Sum(row => row.Field <decimal>("TAX_AMOUNT")); //For Total[Sum] Show in Footer--//
GridPurchItems.FooterRow.Cells[10].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[10].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[10].Text = "Tax1 Amt: " + TaxAmount.ToString("N2");
GridPurchItems.FooterRow.Cells[10].Font.Bold = true;
decimal AddTaxAmnt = dt.AsEnumerable().Sum(row => row.Field <decimal>("ADDTAX_AMOUNT")); //For Total[Sum] Litre Show in Footer--//
GridPurchItems.FooterRow.Cells[12].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[12].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[12].Text = "Tax2 Amt: " + AddTaxAmnt.ToString("N2");
GridPurchItems.FooterRow.Cells[12].Font.Bold = true;
decimal Discount = dt.AsEnumerable().Sum(row => row.Field <decimal>("DISC_AMOUNT")); //For Total[Sum] Litre Show in Footer--//
GridPurchItems.FooterRow.Cells[13].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[13].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[13].Text = "Disc: " + Discount.ToString("N2");
GridPurchItems.FooterRow.Cells[13].Font.Bold = true;
decimal TDAMOUNT = dt.AsEnumerable().Sum(row => row.Field <decimal>("TDVALUE")); //For Total[Sum] Litre Show in Footer--//
GridPurchItems.FooterRow.Cells[14].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[14].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[14].Text = "TD: " + TDAMOUNT.ToString("N2");
GridPurchItems.FooterRow.Cells[14].Font.Bold = true;
decimal Gross = dt.AsEnumerable().Sum(row => row.Field <decimal>("LINEAMOUNT")); //For Total[Sum] Price Show in Footer--//
GridPurchItems.FooterRow.Cells[15].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[15].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[15].Text = "Gross:" + Gross.ToString("N2");
GridPurchItems.FooterRow.Cells[15].Font.Bold = true;
decimal total = dt.AsEnumerable().Sum(row => row.Field <decimal>("AMOUNT")); //For Total[Sum] Value Show in Footer--//
GridPurchItems.FooterRow.Cells[16].HorizontalAlign = HorizontalAlign.Left;
GridPurchItems.FooterRow.Cells[16].ForeColor = System.Drawing.Color.MidnightBlue;
GridPurchItems.FooterRow.Cells[16].Text = "Net:" + total.ToString("N2");
GridPurchItems.FooterRow.Cells[16].Font.Bold = true;
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void BtnShowReport0_Click1(object sender, EventArgs e)
{
try
{
if (txtFromDate.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select the from date!');", true);
return;
}
if (txtFromDate.Text == "")
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select the to date!');", true);
return;
}
if (Convert.ToDateTime(txtFromDate.Text) > (Convert.ToDateTime(txtToDate.Text)))
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please set from date before to date!');", true);
return;
}
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
string FilterQuery = string.Empty;
DataTable dtSetHeader = null;
DataTable dt = new DataTable();
if (ddlReportType.SelectedValue.ToString() != "0")
{
if (ddlReportType.SelectedValue == "1")
{
dt = GetData("ACX_USP_VAT_SALETAXREPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "2")
{
dt = GetData("ACX_USP_VAT_SALETAXSUMMARYREPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "3")
{
dt = GetData("ACX_USP_CUSTOMERWISE_VAT_REPORT_SALES", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "4")
{
dt = GetData("ACX_USP_VAT_PURCHASETAXREPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "5")
{
dt = GetData("ACX_USP_VAT_PURCHASETAX_SUMMARY_REPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "6")
{
dt = GetData("ACX_USP_VAT_PRODUCTWISEINPUTOUTPUT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "8")
{
dt = GetData("ACX_USP_VAT_PURCHASEREGISTER_REPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "9")
{
dt = GetData("ACX_USP_VAT_SALESREGISTER_REPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "10")
{
dt = GetData("ACX_USP_VAT_ANNEXURE_AB_SALES_REPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "11")
{
dt = GetData("ACX_USP_VAT_ANNEXURE_AB_PURCHASE_REPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
if (ddlReportType.SelectedValue == "12")
{
dt = GetData("ACX_USP_VAT_INPUTVATREPORT", ddlReportType.SelectedItem.Text.ToString(), obj, ref dtSetHeader);
}
}
else
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please select Report Type!');", true);
return;
}
if (dt != null && dt.Rows.Count > 0)
{
gvDetail.DataSource = dt;
gvDetail.DataBind();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void POSTInvoiceData()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
conn = obj.GetConnection();
string PostDocumentNo = string.Empty;
if (Session[SessionGrid] == null)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", "alert('Session Expired.'); window.location.href='frmPendingPurchaseReciept.aspx';", true);
return;
}
DataTable dtGrid = (DataTable)Session[SessionGrid];
try
{
#region Generate New Posted Invoice Number
cmd = new SqlCommand();
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.Text;
DataTable dtNumSeq = obj.GetNumSequenceNew(2, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString());
string NUMSEQ = string.Empty;
if (dtNumSeq != null)
{
PostDocumentNo = dtNumSeq.Rows[0][0].ToString();
NUMSEQ = dtNumSeq.Rows[0][1].ToString();
}
else
{
return;
}
#endregion
cmd.CommandText = string.Empty;
cmd.CommandType = CommandType.Text;
#region Insert Header
DataSet ds = new DataSet();
ds = new DataSet();
DataTable dtLineItem = new DataTable();
dtLineItem = dtGrid.Copy();
dtLineItem.TableName = "SDPurchReceiptLine";
dtLineItem.Columns["REMARKS"].ReadOnly = false;
for (int i = 0; i < GridPurchItems.Rows.Count; i++)
{
int LineNo = Convert.ToInt16(GridPurchItems.Rows[i].Cells[1].Text.ToString());
TextBox txtRemark = (TextBox)GridPurchItems.Rows[i].Cells[17].FindControl("txtRemark");
DataRow[] dr = dtLineItem.Select("LINE_NO=" + LineNo);
if (dr.Length > 0)
{
dr[0]["REMARKS"] = txtRemark.Text;
dtLineItem.AcceptChanges();
}
}
ds.Tables.Add(dtLineItem);
string InvoiceLineXml = ds.GetXml();
string GstRegDate;
GstRegDate = Convert.ToString(Session["SITEGSTINREGDATE"]) == "" ? null : Convert.ToDateTime(Session["SITEGSTINREGDATE"]).ToString("yyyy-MM-dd");
cmd.CommandText = "ACX_ACXPURCHINVRECIEPT";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Document_No", PostDocumentNo);
cmd.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString());
cmd.Parameters.AddWithValue("@Site_Code", Session["SiteCode"].ToString());
cmd.Parameters.AddWithValue("@Document_Date", DateTime.Now);
cmd.Parameters.AddWithValue("@Purchase_Indent_No", txtIndentNo.Text.Trim());
cmd.Parameters.AddWithValue("@Purchase_Indent_Date", txtIndentDate.Text);
cmd.Parameters.AddWithValue("@SO_No", txtSONo.Text.Trim());
cmd.Parameters.AddWithValue("@SO_Date", DateTime.Now);
cmd.Parameters.AddWithValue("@STATUS", 1);
cmd.Parameters.AddWithValue("@Material_Value", Convert.ToDecimal(txtReceiptValue.Text));
cmd.Parameters.AddWithValue("@Purchase_Reciept_No", PostDocumentNo);
cmd.Parameters.AddWithValue("@Sale_InvoiceDate", txtReceiptDate.Text);
cmd.Parameters.AddWithValue("@Sale_InvoiceNo", txtInvoiceNo.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@Transporter_Code", txtTransporterName.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@VEHICAL_No", txtvehicleNo.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@VEHICAL_Type", txtVehicleType.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@PREDOCUMENT_NO", string.Empty);
cmd.Parameters.AddWithValue("@NUMSEQ", NUMSEQ);
cmd.Parameters.AddWithValue("@DRIVERNAME", txttransporterNo.Text.Trim().ToString());
cmd.Parameters.AddWithValue("@Supplier_Code", txtDistributorCode.Text.Trim());
cmd.Parameters.AddWithValue("@DISTGSTINNO", Convert.ToString(Session["SITEGSTINNO"]));
cmd.Parameters.AddWithValue("@DISTGSTINREGDATE", GstRegDate);
cmd.Parameters.AddWithValue("@DISTCOMPOSITIONSCHEME", (Convert.ToBoolean(Session["SITECOMPOSITIONSCHEME"]) == true ? 1 : 0));
cmd.Parameters.AddWithValue("@VENDGSTINNO", Convert.ToString(txtGstno.Text));
cmd.Parameters.AddWithValue("@VENDGSTINREGDATE", Convert.ToString(txtReceiptDate.Text));
cmd.Parameters.AddWithValue("@VENDCOMPOSITIONSCHEME", (Convert.ToBoolean(txtcomposition.Text) == true ? 1 : 0));
cmd.Parameters.AddWithValue("@XmlData", InvoiceLineXml);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
//SqlDataAdapter sda = new SqlDataAdapter(cmd);
//DataTable dt = new DataTable();
//sda.Fill(dt);
#endregion
transaction.Commit();
Session[SessionGrid] = null;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Invoice Posted Successfully ! Document Number : " + PostDocumentNo + " ');", true);
//UpdateTransTable(PostDocumentNo, transaction, conn);
RefreshCompletePage();
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
transaction.Rollback();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
if (transaction != null)
{
transaction.Dispose();
}
}
}
private void LoadDataInReportViewerDetail(DataTable dtSetData)
{
try
{
if (dtSetData.Rows.Count > 0)
{
DataTable DataSetParameter = new DataTable();
DataSetParameter.Columns.Add("FromDate");
DataSetParameter.Columns.Add("ToDate");
DataSetParameter.Columns.Add("SchemeCode");
DataSetParameter.Columns.Add("Scheme");
DataSetParameter.Rows.Add();
DataSetParameter.Rows[0]["FromDate"] = txtFromDate.Text;
DataSetParameter.Rows[0]["ToDate"] = txtToDate.Text;
if (ddlSiteIdNew.SelectedIndex != -1)
{
if (ddlSiteIdNew.SelectedItem.Text == "Select...")
{
DataSetParameter.Rows[0]["SchemeCode"] = "All";
}
else
{
DataSetParameter.Rows[0]["SchemeCode"] = ddlSiteIdNew.SelectedItem.Text;
}
}
else
{
DataSetParameter.Rows[0]["SchemeCode"] = "All";
}
if (ddlSchemeNew.SelectedItem.Text == "Select...")
{
DataSetParameter.Rows[0]["SchemeCode"] = "All";
}
else
{
DataSetParameter.Rows[0]["SchemeCode"] = ddlSchemeNew.SelectedItem.Text;
}
ReportDataSource RDS1 = new ReportDataSource("DataSet1", dtSetData);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource RDS2 = new ReportDataSource("DataSet2", DataSetParameter);
ReportViewer1.LocalReport.DataSources.Add(RDS2);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\SCHEMEDATAREPORT.rdl");
//ReportViewer1.LocalReport.Refresh();
ReportViewer1.Visible = true;
}
else
{
LblMessage.Text = "No Records Exists !!";
ReportViewer1.Visible = false;
}
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
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
}
protected void radGridCurrentOrder_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
try
{
if (e.CommandName == "RowClick" || e.CommandName == "ExpandCollapse")
{
bool lastState = e.Item.Expanded;
if (e.CommandName == "ExpandCollapse")
{
lastState = !lastState;
}
CollapseAllRows();
e.Item.Expanded = !lastState;
}
else if (e.CommandName.Equals("ClearFilter"))
{
foreach (GridColumn column in radGridCurrentOrder.MasterTableView.Columns)
{
column.CurrentFilterFunction = GridKnownFunction.NoFilter;
column.CurrentFilterValue = string.Empty;
}
radGridCurrentOrder.MasterTableView.FilterExpression = string.Empty;
radGridCurrentOrder.MasterTableView.Rebind();
}
else if (e.CommandName.Equals("Refresh"))
{
foreach (GridColumn column in radGridCurrentOrder.MasterTableView.Columns)
{
column.CurrentFilterFunction = GridKnownFunction.NoFilter;
column.CurrentFilterValue = string.Empty;
}
radGridCurrentOrder.MasterTableView.FilterExpression = string.Empty;
radGridCurrentOrder.DataSource = null;
BindGridCurrentOrder();
}
else if (e.CommandName.Equals("GenerateBoxTicket"))
{
Label lblOrderId = (Label)e.Item.FindControl("lblOrderIdV");
Int64 orderId = Convert.ToInt64(lblOrderId.Text);
Thread thread = new Thread(() => GenerateBoxTicket(orderId));
thread.Start();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "GeneratePackingPDFNotification", "GeneratePackingPDFNotification();", true);
}
else if (e.CommandName.Equals("DownloadBoxTicket"))
{
Label lblOrderId = (Label)e.Item.FindControl("lblOrderIdV");
Int64 orderId = Convert.ToInt64(lblOrderId.Text);
DownloadBoxTicket(orderId);
}
else if (e.CommandName.Equals("GeneratePackingPDF"))
{
Label lblOrderId = (Label)e.Item.FindControl("lblOrderIdV");
Int64 orderId = Convert.ToInt64(lblOrderId.Text);
GeneratePackingPdfs(orderId);
}
}
catch (Exception ex)
{
//write to Elma
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new CreamBell_DMS_WebApps.App_Code.Global();
SqlConnection conn = null;
SqlCommand cmd = null;
DataTable dtDataByfilter1 = null;
string query = string.Empty;
try
{
conn = new SqlConnection(objGlobal.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
query = "ACX_STOCKLEDGER";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@FromDate", txtFromDate.Text);
cmd.Parameters.AddWithValue("@ToDate", txtToDate.Text);
// site
if (ddlSiteId.SelectedIndex > 0)
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
else if (ddlSiteId.SelectedItem.Text != "All...")
{
cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
}
//bucode
if (ddlBusinessUnit.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@BUCODE", ddlBusinessUnit.SelectedItem.Value);
}
if (ddlBusinessUnit.SelectedIndex == 0 || ddlBusinessUnit.SelectedItem.Text == "All...")
{
cmd.Parameters.AddWithValue("@BUCODE", "");
}
//ItemId
if (drpProduct.SelectedIndex >= 1)
{
cmd.Parameters.AddWithValue("@ItemId", drpProduct.SelectedItem.Value);
}
if (drpProduct.SelectedIndex == 0 || drpProduct.Text == "All...")
{
cmd.Parameters.AddWithValue("@ItemId", "");
}
//WareLocation
if (ddlWarehouse.SelectedIndex >= 0)
{
cmd.Parameters.AddWithValue("@TransLocation", ddlWarehouse.SelectedItem.Value);
}
if (rdoDetail.Checked == true)
{
cmd.Parameters.AddWithValue("@Type", 0);
}
else
{
cmd.Parameters.AddWithValue("@Type", 1);
}
dtDataByfilter1 = new DataTable();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
//dtDataByfilter1.Load(cmd.ExecuteReader());
LoadDataInReportViewer(dt);
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (conn != null)
{
if (conn.State.ToString() == "Open")
{
conn.Close();
}
}
}
}
