private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new Global();
DataTable dtDataByfilter = null;
try
{
#region oldCode
//conn = new SqlConnection(objGlobal.GetConnectionString());
//cmd = new SqlCommand();
//cmd.CommandTimeout = 0;
//cmd.CommandType = CommandType.StoredProcedure;
//query = "usp_GetCustomerOutstandingAgingReport";
//cmd.CommandText = query;
//if (!string.IsNullOrEmpty(txt30.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@FirstParm", txt30.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@FirstParm", 0);
//}
//if (!string.IsNullOrEmpty(txt60.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@SecondParm", txt60.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@SecondParm", 0);
//}
//if (!string.IsNullOrEmpty(txt90.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@Third", txt90.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@Third", 0);
//}
//if (!string.IsNullOrEmpty(txt120.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@Fourth", txt120.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@Fourth", 0);
//}
//if (!string.IsNullOrEmpty(txtOver120.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@FiveParm", txtOver120.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@FiveParm", 0);
//}
//string strStateCode = "";
//string strSiteCode = "";
//if (Convert.ToString(Session["LOGINTYPE"]) == "3") {
// strStateCode = ucRoleFilters.GetCommaSepartedStateId();
// strSiteCode = ucRoleFilters.GetCommaSepartedSiteId();
//} else {
// foreach (ListItem item in chkListState.Items)
// {
// if (item.Selected)
// {
// if (strStateCode == "")
// {
// strStateCode += "" + item.Value.ToString() + "";
// }
// else
// {
// strStateCode += "," + item.Value.ToString() + "";
// }
// }
// }
// foreach (ListItem item in chkListSite.Items)
// {
// if (item.Selected)
// {
// if (strSiteCode == "")
// {
// strSiteCode += "" + item.Value.ToString() + "";
// }
// else
// {
// strSiteCode += "," + item.Value.ToString() + "";
// }
// }
// }
//}
//if (strStateCode.Length > 0)
//{
// cmd.Parameters.AddWithValue("@STATECODE", strStateCode);
//}
//else
//{
// cmd.Parameters.AddWithValue("@STATECODE", "");
//}
//if (strSiteCode.Length > 0)
//{
// cmd.Parameters.AddWithValue("@SiteCode", strSiteCode);
//}
//else
//{
// cmd.Parameters.AddWithValue("@SiteCode", "");
//}
//string strCustomerGroup = "";
//foreach (ListItem item in chkListCustomerGroup.Items)
//{
// if (item.Selected)
// {
// if (strCustomerGroup == "")
// {
// strCustomerGroup += "" + item.Value.ToString() + "";
// }
// else
// {
// strCustomerGroup += "," + item.Value.ToString() + "";
// }
// }
//}
//if (strCustomerGroup.Length > 0)
//{
// cmd.Parameters.AddWithValue("@Cust_Group", strCustomerGroup);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Cust_Group", "");
//}
//string strCustomerName = "";
//foreach (ListItem item in chkCustomerName.Items)
//{
// if (item.Selected)
// {
// if (strCustomerName == "")
// {
// strCustomerName = item.Value.ToString();
// }
// else
// {
// strCustomerName += "," + item.Value.ToString() + "";
// }
// }
//}
//if (strCustomerName.Length > 0)
//{
// cmd.Parameters.AddWithValue("@Customer_Code", strCustomerName);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Customer_Code", "");
//}
//dtDataByfilter = new DataTable();
//cmd.Connection = objGlobal.GetConnection();
//dtDataByfilter.Load(cmd.ExecuteReader());
#endregion
SqlParameter[] sqlParameters = null;
SqlParameter sqlParameterFirstParm = null;
SqlParameter sqlParameterSecondParm = null;
SqlParameter sqlParameterThird = null;
SqlParameter sqlParameterFourth = null;
SqlParameter sqlParameterFiveParm = null;
SqlParameter sqlParameterSTATECODE = null;
SqlParameter sqlParameterSiteCode = null;
SqlParameter sqlParameterCust_Group = null;
SqlParameter sqlParameterCustomer_Code = null;
if (!string.IsNullOrEmpty(txt30.Text.Trim()))
{
sqlParameterFirstParm = new SqlParameter("@FirstParm", txt30.Text.Trim());
}
else
{
sqlParameterFirstParm = new SqlParameter("@FirstParm", 0);
sqlParameterFirstParm.Value = 0;
}
if (!string.IsNullOrEmpty(txt60.Text.Trim()))
{
sqlParameterSecondParm = new SqlParameter("@SecondParm", txt60.Text.Trim());
}
else
{
sqlParameterSecondParm = new SqlParameter("@SecondParm", 0);
sqlParameterSecondParm.Value = 0;
}
if (!string.IsNullOrEmpty(txt90.Text.Trim()))
{
sqlParameterThird = new SqlParameter("@Third", txt90.Text.Trim());
}
else
{
sqlParameterThird = new SqlParameter("@Third", 0);
sqlParameterThird.Value = 0;
}
if (!string.IsNullOrEmpty(txt120.Text.Trim()))
{
sqlParameterFourth = new SqlParameter("@Fourth", txt120.Text.Trim());
}
else
{
sqlParameterFourth = new SqlParameter("@Fourth", 0);
sqlParameterFourth.Value = 0;
}
if (!string.IsNullOrEmpty(txtOver120.Text.Trim()))
{
sqlParameterFiveParm = new SqlParameter("@FiveParm", txtOver120.Text.Trim());
}
else
{
sqlParameterFiveParm = new SqlParameter("@FiveParm", 0);
sqlParameterFiveParm.Value = 0;
}
string strStateCode = "";
string strSiteCode = "";
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
strStateCode = ucRoleFilters.GetCommaSepartedStateId();
strSiteCode = ucRoleFilters.GetCommaSepartedSiteId();
}
else
{
foreach (ListItem item in chkListState.Items)
{
if (item.Selected)
{
if (strStateCode == "")
{
strStateCode += "" + item.Value.ToString() + "";
}
else
{
strStateCode += "," + item.Value.ToString() + "";
}
}
}
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (strSiteCode == "")
{
strSiteCode += "" + item.Value.ToString() + "";
}
else
{
strSiteCode += "," + item.Value.ToString() + "";
}
}
}
}
if (strStateCode.Length > 0)
{
sqlParameterSTATECODE = new SqlParameter("@STATECODE", strStateCode);
}
else
{
sqlParameterSTATECODE = new SqlParameter("@STATECODE", "");
}
if (strSiteCode.Length > 0)
{
sqlParameterSiteCode = new SqlParameter("@SiteCode", strSiteCode);
}
else
{
sqlParameterSiteCode = new SqlParameter("@SiteCode", "");
}
string strCustomerGroup = "";
foreach (ListItem item in chkListCustomerGroup.Items)
{
if (item.Selected)
{
if (strCustomerGroup == "")
{
strCustomerGroup += "" + item.Value.ToString() + "";
}
else
{
strCustomerGroup += "," + item.Value.ToString() + "";
}
}
}
if (strCustomerGroup.Length > 0)
{
sqlParameterCust_Group = new SqlParameter("@Cust_Group", strCustomerGroup);
}
else
{
sqlParameterCust_Group = new SqlParameter("@Cust_Group", "");
}
string strCustomerName = "";
foreach (ListItem item in chkCustomerName.Items)
{
if (item.Selected)
{
if (strCustomerName == "")
{
strCustomerName = item.Value.ToString();
}
else
{
strCustomerName += "," + item.Value.ToString() + "";
}
}
}
if (strCustomerName.Length > 0)
{
sqlParameterCustomer_Code = new SqlParameter("@Customer_Code", strCustomerName);
}
else
{
sqlParameterCustomer_Code = new SqlParameter("@Customer_Code", "");
}
sqlParameters = new SqlParameter[] { sqlParameterFirstParm, sqlParameterSecondParm, sqlParameterThird, sqlParameterFourth, sqlParameterFiveParm, sqlParameterSTATECODE,
sqlParameterSiteCode, sqlParameterCust_Group, sqlParameterCustomer_Code };
dtDataByfilter = CreamBellFramework.GetDataFromStoredProcedure("dbo.usp_GetCustomerOutstandingAgingReport", sqlParameters);
LoadDataInReportViewer(dtDataByfilter);
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
objGlobal.CloseSqlConnection();
}
}
public virtual void Log(Exception exception)
{
ErrorSignal.FromCurrentContext().Raise(exception);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
CreamBell_DMS_WebApps.App_Code.Global baseObj = new Global();
if (txtFromDate.Text.Trim().Length > 0)
{
if (!baseObj.IsDate(txtFromDate.Text))
{
string message = "alert('Invalid From Date !!!');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true);
txtFromDate.Focus();
return;
}
}
if (txtToDate.Text.Trim().Length > 0)
{
if (!baseObj.IsDate(txtToDate.Text))
{
string message = "alert('Invalid To Date !!!');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true);
txtToDate.Focus();
return;
}
}
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
bool b = ValidateSearch();
GridView1.DataSource = null;
GridView2.DataSource = null;
GridView2.DataBind();
if (b == true)
{
DateTime endDate = Convert.ToDateTime(this.txtToDate.Text);
//endDate.AddDays(1);
//DateTime end = endDate.AddDays(1);
string FromDate = Convert.ToDateTime(txtFromDate.Text).ToString("dd-MMM-yyyy");
string ToDate = endDate.ToString("dd-MMM-yyyy");
//string query = "Select A.INVOICE_NO, A.INVOIC_DATE, A.SO_NO,case when CONVERT(VARCHAR(10),SO_DATE , 103) = '01/01/1900' then '' else CONVERT(VARCHAR(10),SO_DATE , 103) end AS SO_DATE, ('[' +A.CUSTOMER_CODE +']' + ' ' + B.CUSTOMER_NAME) as CUSTOMER , A.INVOICE_VALUE " +
// " from ax.ACXSALEINVOICEHEADER A INNER JOIN AX.ACXCUSTMASTER B ON A.CUSTOMER_CODE=B.CUSTOMER_CODE " +
// " where SITEID= '" + Session["SiteCode"].ToString() + "' and Invoic_Date>='" + FromDate + "' and Invoic_Date<='" + ToDate + "'";
string query = "Select A.INVOICE_NO, A.INVOIC_DATE, A.SO_NO,case when CONVERT(VARCHAR(10),SO_DATE , 103) = '01/01/1900' then '' else CONVERT(VARCHAR(10),SO_DATE , 103) end AS SO_DATE, ('[' +A.CUSTOMER_CODE +']' + ' ' + B.CUSTOMER_NAME) as CUSTOMER , A.INVOICE_VALUE " +
" from ax.ACXSALEINVOICEHEADER A INNER JOIN AX.ACXCUSTMASTER B ON A.CUSTOMER_CODE=B.CUSTOMER_CODE " +
" where SITEID IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ") and Invoic_Date>='" + FromDate + "' and Invoic_Date<='" + ToDate + "'";
if (txtInvoiceNoStart.Text != string.Empty && txtInvoiceNoEnd.Text != string.Empty)
{
try
{
string[] strInvoicefromsplit = txtInvoiceNoStart.Text.Split('-');
string[] strInvoiceTosplit = txtInvoiceNoEnd.Text.Split('-');
query = query + "and cast(Right(A.invoice_no,6) as int) between " + strInvoicefromsplit[1] + " and " + strInvoiceTosplit[1] + " ";
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Invoice number is not in correct format !! ');", true);
GridView1.DataSource = null;
GridView1.DataBind();
return;
}
}
if (rdoSI.Checked == true)
{
query = query + " and A.TranType=1 ";
}
else if (rdoSR.Checked == true)
{
query = query + " and A.TranType=2 ";
}
else if (rdoFOC.Checked == true)
{
query = query + " and A.TranType=3 ";
}
if (drpPSRNew.SelectedItem != null && drpPSRNew.SelectedItem.Text != string.Empty && drpPSRNew.SelectedItem.Text != "Select...")
{
query = query + "and B.psr_code='" + drpPSRNew.SelectedItem.Value + "' ";
if (drpBeatNew.SelectedItem != null && drpBeatNew.SelectedItem.Text != string.Empty && drpBeatNew.SelectedItem.Text != "Select...")
{
query = query + "and B.psr_beat='" + drpBeatNew.SelectedItem.Value + "' ";
if (drpCustomerNew.SelectedItem != null && drpCustomerNew.Text != string.Empty && drpCustomerNew.Text != "Select...")
{
query = query + "and A.CUSTOMER_CODE='" + drpCustomerNew.SelectedItem.Value + "' ";
}
}
}
if (ddlSearchNew.Items[ddlSearchNew.SelectedIndex].Text == "Sales Invoice No")
{
query = query + " and INVOICE_NO like '%" + txtSearch.Text.Trim().ToString() + "%'";
}
if (ddlSearchNew.Items[ddlSearchNew.SelectedIndex].Text == "Customer")
{
query = query + " and (A.CUSTOMER_CODE like '%" + txtSearch.Text.Trim().ToString() + "%' or B.CUSTOMER_NAME like '%" + txtSearch.Text.Trim().ToString() + "%') ";
}
query = query + " ORDER BY a.INVOIC_DATE DESC,a.INVOICE_NO DESC";
DataTable dtFilter = obj.GetData(query);
if (dtFilter.Rows.Count > 0)
{
GridView1.DataSource = dtFilter;
GridView1.DataBind();
CheckBox chk = (CheckBox)GridView1.HeaderRow.FindControl("checkAll");
chk.Checked = true;
foreach (GridViewRow grv in GridView1.Rows)
{
CheckBox chkAll = (CheckBox)grv.Cells[0].FindControl("chklist");
chkAll.Checked = true;
}
// uppanel.Update();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('No Data Exist !! ');", true);
GridView1.DataSource = null;
GridView1.DataBind();
//GridDetail();
txtSearch.Text = string.Empty;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataCatalogBiz bizRule = new DataCatalogBiz();
if (bizRule.IsCatalogExist(RadListBoxSource.SelectedValue))
{
this.lblmsgs.Text = MessageFormatter.GetFormattedNoticeMessage("Catalog Already Exists");
return;
}
if (RadListBoxDestination.CheckedItems.Count < 1)
{
this.lblmsgs.Text = MessageFormatter.GetFormattedNoticeMessage("At least 1 Catalog Attribute must be selected.");
return;
}
using (OracleConnection connection = new OracleConnection(connString))
{
string strSQL = @"insert into MDM_DQI_PARAMETERS(table_categories, table_names,table_desc,column_names,column_desc,
created_by,created_date,record_status,column_order)
values(:table_categories, :table_names,:table_desc,:column_names,:column_desc,
:created_by,:created_date,:record_status, :column_order)";
try
{
connection.Open();
OracleCommand command = new OracleCommand(strSQL, connection);
command.BindByName = true;
command.CommandType = System.Data.CommandType.Text;
foreach (var item in RadListBoxDestination.CheckedItems)
{
command.Parameters.Add(":table_categories", OracleDbType.Varchar2).Value = "A";
command.Parameters.Add(":table_names", OracleDbType.Varchar2).Value = RadListBoxSource.SelectedValue;
command.Parameters.Add(":table_desc", OracleDbType.Varchar2).Value = RadListBoxSource.SelectedValue;
command.Parameters.Add(":column_names", OracleDbType.Varchar2).Value = item.Text;
command.Parameters.Add(":column_desc", OracleDbType.Varchar2).Value = item.Text;
command.Parameters.Add(":created_by", OracleDbType.Varchar2).Value = User.Identity.Name;
command.Parameters.Add(":created_date", OracleDbType.Date).Value = DateTime.Now;
command.Parameters.Add(":record_status", OracleDbType.Varchar2).Value = "Y";
command.Parameters.Add(":column_order", OracleDbType.Int32).Value = item.Value;
command.ExecuteNonQuery();
command.Parameters.Clear();
}
gridCat.Rebind();
this.lblmsgs.Text = MessageFormatter.GetFormattedSuccessMessage("Catalog Added Succesfully");
//command.Parameters.Add(":table_categories", OracleDbType.Varchar2).Value = "";
//cmd.BindByName = true;
//cmd.CommandText = "insert into MDM_WEIGHTS (WEIGHT_VALUE,CREATED_BY,CREATED_DATE,RECORD_STATUS,WEIGHT_DESC)" +
// " values (:p_WeightVal,:p_createdby,:p_createdDate,:p_recStatus,:p_weight_desc)";//
//OracleParameter prm = new OracleParameter();
//cmd.Parameters.Add(":p_WeightVal", OracleDbType.Int16).Value = this.txtWeightValue.Text;
//cmd.Parameters.Add(":p_createdby", OracleDbType.NVarchar2).Value = "Admin";
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
lblmsgs.Text = MessageFormatter.GetFormattedErrorMessage(ex.Message);
}
}
}
public ActionResult ProcessPayment(PaymentForm pf)
{
Response.NoCache();
#if DEBUG
#else
if (Session["FormId"] != null)
{
if ((Guid)Session["FormId"] == pf.FormId)
{
return(Message("Already submitted"));
}
}
#endif
OnlineRegModel m = null;
var ed = CurrentDatabase.RegistrationDatas.SingleOrDefault(e => e.Id == pf.DatumId);
if (ed != null)
{
m = Util.DeSerialize <OnlineRegModel>(ed.Data);
}
#if DEBUG
#else
if (m != null && m.History.Any(h => h.Contains("ProcessPayment")))
{
return(Content("Already submitted"));
}
#endif
int?datumid = null;
if (m != null)
{
datumid = m.DatumId;
var msg = m.CheckDuplicateGift(pf.AmtToPay);
if (Util.HasValue(msg))
{
return(Message(msg));
}
}
if (IsCardTester(pf, "Payment Page"))
{
return(Message("Found Card Tester"));
}
if (CurrentDatabase.Setting("UseRecaptcha"))
{
if (!GoogleRecaptcha.IsValidResponse(HttpContext, CurrentDatabase))
{
CurrentDatabase.LogActivity("OnlineReg Error ReCaptcha validation failed.", pf.OrgId, did: datumid);
ModelState.AddModelError("form", "ReCaptcha validation failed.");
return(View("Payment/Process", pf));
}
}
SetHeaders(pf.OrgId ?? 0);
var ret = pf.ProcessPayment(ModelState, m);
switch (ret.Route)
{
case RouteType.ModelAction:
return(View(ret.View, ret.Model));
case RouteType.AmtDue:
ViewBag.amtdue = ret.AmtDue;
return(View(ret.View, ret.Transaction));
case RouteType.Error:
CurrentDatabase.LogActivity("OnlineReg Error " + ret.Message, pf.OrgId, did: datumid);
return(Message(ret.Message));
case RouteType.ValidationError:
return(View(ret.View, pf));
default: // unexptected Route
if (ModelState.IsValid)
{
ErrorSignal.FromCurrentContext().Raise(new Exception("OnlineReg Unexpected route datum= " + datumid));
CurrentDatabase.LogActivity("OnlineReg Unexpected Route " + ret.Message, oid: pf.OrgId, did: datumid);
ModelState.AddModelError("form", "unexpected error in payment processing");
}
return(View(ret.View ?? "Payment/Process", pf));
}
}
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);
}
}
protected void btn2_Click(object sender, EventArgs e)
{
string sitecode1;
sitecode1 = Session["SiteCode"].ToString();
gvDetails.DataSource = null;
gvDetails.DataBind();
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
conn = obj.GetConnection();
try
{
if (drpSearch.SelectedItem.Text == "SO Number")
{
adp1 = new SqlDataAdapter("Select h.SO_No,h.[DELIVERY_DATE],C.CUST_GROUP,h.Customer_Code" +
",C.CUSTOMER_NAME,C.ADDRESS1,APB.BeatName ,C.PSR_BEAT,h.SO_DATE,SO_Value,psr.PSR_Name , h.PSR_CODE,h.PSR_CODE,case when h.App_SO_NO!='' then 'MOBILE' else 'MANUAL' end as SOTYPE " +
" from [ax].[ACXSALESHEADER] h Inner Join " +
" [ax].[ACXCUSTMASTER] C on h.Customer_Code = C.Customer_Code" +
//" and C.[DATAAREAID] = h.[DATAAREAID] " +
" left join [ax].[ACXPSRBeatMaster] APB on c.PSR_BEAT = APB.BeatCode and h.PSR_CODE = APB.PSRCode " +
" left join [ax].[ACXPSRMaster] psr on h.PSR_CODE = psr.PSR_Code " +
" where loadsheet_Status = 0 and h.siteid = '" + sitecode1 + "' " +
" and h.SO_NO like '%" + txtSerch.Text + "%' " +
" order by h.[DELIVERY_DATE] asc,h.SO_DATE asc", conn);
}
else if (drpSearch.SelectedItem.Text == "Date")
{
adp1 = new SqlDataAdapter("Select h.SO_No,h.[DELIVERY_DATE],C.CUST_GROUP,h.Customer_Code" +
",C.CUSTOMER_NAME,C.ADDRESS1,APB.BeatName ,C.PSR_BEAT,h.SO_DATE,SO_Value,psr.PSR_Name ,h.PSR_CODE,case when h.App_SO_NO!='' then 'MOBILE' else 'MANUAL' end as SOTYPE " +
" from [ax].[ACXSALESHEADER] h Inner Join " +
" [ax].[ACXCUSTMASTER] C on h.Customer_Code = C.Customer_Code" +
//" and C.[DATAAREAID] = h.[DATAAREAID] " +
" left join [ax].[ACXPSRBeatMaster] APB on c.PSR_BEAT = APB.BeatCode and h.PSR_CODE = APB.PSRCode " +
" left join [ax].[ACXPSRMaster] psr on h.PSR_CODE = psr.PSR_Code " +
" where loadsheet_Status = 0 and h.siteid = '" + sitecode1 + "' " +
" and h.SO_DATE = '" + Convert.ToDateTime(txtSerch.Text).ToString("dd-MMM-yyyy") + "' " +
" order by h.[DELIVERY_DATE] asc,h.SO_DATE asc", conn);
}
else if (drpSearch.SelectedItem.Text == "Customer Group")
{
adp1 = new SqlDataAdapter("Select h.SO_No,h.[DELIVERY_DATE],C.CUST_GROUP,h.Customer_Code" +
",C.CUSTOMER_NAME,C.ADDRESS1,APB.BeatName ,C.PSR_BEAT,h.SO_DATE,SO_Value,psr.PSR_Name ,h.PSR_CODE,case when h.App_SO_NO!='' then 'MOBILE' else 'MANUAL' end as SOTYPE " +
" from [ax].[ACXSALESHEADER] h Inner Join " +
" [ax].[ACXCUSTMASTER] C on h.Customer_Code = C.Customer_Code" +
// " and C.[DATAAREAID] = h.[DATAAREAID] " +
" left join [ax].[ACXPSRBeatMaster] APB on c.PSR_BEAT = APB.BeatCode and h.PSR_CODE = APB.PSRCode " +
" left join [ax].[ACXPSRMaster] psr on h.PSR_CODE = psr.PSR_Code " +
" where loadsheet_Status = 0 and h.siteid = '" + sitecode1 + "' " +
" and c.CUST_GROUP like '%" + txtSerch.Text + "%' " +
" order by h.[DELIVERY_DATE] asc,h.SO_DATE asc", conn);
}
else
{
adp1 = new SqlDataAdapter("Select h.SO_No,h.[DELIVERY_DATE],C.CUST_GROUP,h.Customer_Code" +
",C.CUSTOMER_NAME,C.ADDRESS1,APB.BeatName ,C.PSR_BEAT,h.SO_DATE,SO_Value,psr.PSR_Name,h.PSR_CODE,case when h.App_SO_NO!='' then 'MOBILE' else 'MANUAL' end as SOTYPE " +
" from [ax].[ACXSALESHEADER] h Inner Join " +
" [ax].[ACXCUSTMASTER] C on h.Customer_Code = C.Customer_Code" +
//" and C.[DATAAREAID] = h.[DATAAREAID] " +
" left join [ax].[ACXPSRBeatMaster] APB on c.PSR_BEAT = APB.BeatCode and h.PSR_CODE = APB.PSRCode " +
" left join [ax].[ACXPSRMaster] psr on h.PSR_CODE = psr.PSR_Code " +
" where loadsheet_Status = 0 and h.siteid = '" + sitecode1 + "'" +
" and h.PSR_CODE like '%" + txtSerch.Text + "%' " +
" order by h.[DELIVERY_DATE] asc,h.SO_DATE asc", conn);
}
ds2.Clear();
adp1.Fill(ds2, "dtl");
if (ds2.Tables["dtl"].Rows.Count != 0)
{
gvDetails.DataSource = ds2;
gvDetails.DataBind();
}
GridView2.DataSource = null;
GridView2.DataBind();
GridView2.Visible = false;
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected ActionResult SendJsonErrorResponse(string message)
{
ErrorSignal.FromCurrentContext().Raise(new Exception(string.Format("{0}: {1}", sessionid, message)));
return(Json(message.ToJsonFail(), JsonRequestBehavior.AllowGet));
}
protected ActionResult SendJsonNoPermission(string message = "You are not allowed to do that")
{
ErrorSignal.FromCurrentContext().Raise(new Exception(string.Format("{0}: {1}", sessionid, message)));
return(Json(message.ToJsonFail(), JsonRequestBehavior.AllowGet));
}
private void ShowData_ForExcel()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
string FilterQuery = string.Empty;
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = new SqlConnection(obj.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.Text;
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 ";
if (DDLSearchFilter.Text == "PSR Name")
{
query += " and A.PSRCode=(select D.PSR_Code from [ax].[ACXPSRMaster] D where D.PSR_Code=A.PSRCode and D.PSR_Name like '%" + txtSearch.Text + "%')";
}
query += "Order By PSRName,A.[FromDate] Desc";
DataTable dt = obj.GetData(query);
//dt = new DataTable();
//dt.Load(cmd.ExecuteReader());
//=================Create Excel==========
string attachment = "attachment; filename=PSRDistributorLinkingMaster.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);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
}
}
protected ActionResult SendJsonErrorResponse(Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
return(Json("Oops, we did something wrong. This will be fixed within 24 hours.".ToJsonFail(), JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "id,LeagueName,TeamSize,Active,rowversion,TiesAllowed,PointsCount,WinPoints,TiePoints,ByePoints,StartWeek")] League league)
{
try
{
if (ModelState.IsValid)
{
_db.Entry(league).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var clientValues = (League)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
ModelState.AddModelError(string.Empty,
"Unable to save changes. The league was deleted by another user.");
}
else
{
var databaseValues = (League)databaseEntry.ToObject();
if (databaseValues.LeagueName != clientValues.LeagueName)
{
ModelState.AddModelError("League Name", "Current value: "
+ databaseValues.LeagueName);
}
if (databaseValues.TeamSize != clientValues.TeamSize)
{
ModelState.AddModelError("Team Size", "Current value: "
+ databaseValues.TeamSize);
}
if (databaseValues.Active != clientValues.Active)
{
ModelState.AddModelError("Active", "Current value: "
+ databaseValues.Active);
}
if (databaseValues.TiesAllowed != clientValues.TiesAllowed)
{
ModelState.AddModelError("Ties Allowed", "Current value: "
+ databaseValues.TiesAllowed);
}
if (databaseValues.PointsCount != clientValues.PointsCount)
{
ModelState.AddModelError("Do Points Count", "Current value: "
+ databaseValues.PointsCount);
}
if (databaseValues.WinPoints != clientValues.WinPoints)
{
ModelState.AddModelError("Win Points", "Current value: "
+ databaseValues.WinPoints);
}
if (databaseValues.TiePoints != clientValues.TiePoints)
{
ModelState.AddModelError("Tie Points", "Current value: "
+ databaseValues.TiePoints);
}
if (databaseValues.ByePoints != clientValues.ByePoints)
{
ModelState.AddModelError("Bye Points", "Current value: "
+ databaseValues.ByePoints);
}
if (databaseValues.StartWeek != clientValues.StartWeek)
{
ModelState.AddModelError("Start Week", "Current value: "
+ databaseValues.StartWeek);
}
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.");
league.rowversion = databaseValues.rowversion;
}
}
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(league));
}
protected void BtnLogin_Click1(object sender, ImageClickEventArgs e)
{
//Response.Redirect("frmStockLocationTransfer.aspx");
try
{
CreamBell_DMS_WebApps.App_Code.Global obj = new Global();
conn = obj.GetConnection();
string query = "Acx_getUserCredentials";
//string query = "ACX_GetLoginDetails";
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = query;
cmd.Parameters.Add(new SqlParameter("@User_Code", txtUserName.Text.Trim()));
cmd.Parameters.Add(new SqlParameter("@User_Password", txtPassword.Text.Trim()));
RD = cmd.ExecuteReader();
if (RD.HasRows == false)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Login Failed !');", true);
txtPassword.Text = string.Empty;
txtUserName.Focus();
}
else
{
RD.Read();
Session[SessionKeys.USERID] = RD["User_Code"].ToString();
Session[SessionKeys.USERNAME] = RD["User_Name"].ToString();
Session[SessionKeys.NAME] = RD["NAME"].ToString();
Session[SessionKeys.SITEADDRESS] = RD["SITEADDRESS"].ToString();
Session[SessionKeys.SITELOCATION] = RD["State"].ToString();
Session[SessionKeys.STATECODE] = RD["STATECODE"].ToString();
Session[SessionKeys.SCHSTATE] = RD["SCHSTATE"].ToString();
Session[SessionKeys.UNIONTERRITORY] = RD["UNIONTERRITORY"].ToString();
Session[SessionKeys.SITEGSTINNO] = RD["GSTINNO"].ToString();
Session[SessionKeys.SITEGSTINREGDATE] = RD["GSTREGISTRATIONDATE"].ToString();
Session[SessionKeys.SITECOMPOSITIONSCHEME] = RD["COMPOSITIONSCHEME"];
Session[SessionKeys.LOGINTYPE] = RD["User_Type"].ToString();
Session[SessionKeys.SITECODE] = RD["Site_Code"].ToString();
Session[SessionKeys.DATAAREAID] = DataAreaID;
RD.Close();
Global.strSessionID = HttpContext.Current.Session.SessionID;
if (Convert.ToString(Session[SessionKeys.LOGINTYPE]) == "0")
{
string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session[SessionKeys.SITECODE].ToString() + "'";
string MainWarehouse = obj.GetScalarValue(query1);
if (MainWarehouse.Trim().Length > 0)
{
Session[SessionKeys.TRANSLOCATION] = MainWarehouse;
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Error", "alert('Main Warehouse setup not defined.');", true); return;
}
}
//UpdateLoginTime();
try
{
Session[SessionKeys.ISDISTRIBUTOR] = "N";
CreamBell_DMS_WebApps.App_Code.Global baseObj = new Global();
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session[SessionKeys.SITECODE].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode == null)
{
Session[SessionKeys.ISDISTRIBUTOR] = "Y";
}
// Pcs Billing Applicable
Session["ApplicableOnState"] = "N";
sqlstr = "EXEC [dbo].[ACX_USP_PCSBillingApplicable] '" + Session[SessionKeys.SCHSTATE].ToString() + "',''";
objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode == null)
{
Session[SessionKeys.APPLICABLEONSTATE] = "N";// objcheckSitecode.ToString();
}
else
{
Session[SessionKeys.APPLICABLEONSTATE] = "Y";
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
//Response.Redirect("frmCustomerPartyMaster.aspx");
// Response.Redirect("Home.aspx");
// Server.Transfer("Home.aspx", false);
Response.Redirect("frmDashboard.aspx", false);
// HttpContext.Current.RewritePath("frmDashboard.aspx");
//Response.Redirect("~/frmDashboard.aspx", false);
// HttpContext.Current.RewritePath("frmDashboard.aspx");
//Response.Redirect("frmPurchaseInvoiceReceipt.aspx");
//Response.Redirect("frmPurchaseReturn.aspx");
//Response.Redirect("ReportSalesInvoice.aspx");
}
if (RD.IsClosed == false)
{
RD.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
catch (System.Data.SqlClient.SqlException sqlex)
{
ErrorSignal.FromCurrentContext().Raise(sqlex);
if (sqlex.Message.ToString().IndexOf("The server was not found or was not accessible.") > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Error", "alert('Connection not established with server. Please check the network connection.');", true); return;
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Error", "alert('" + sqlex.Message.ToString().Replace("'", "''") + "');", true); return;
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
if (ex.Message.ToString().IndexOf("The timeout period elapsed prior to obtaining a connection from the pool.") > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Error", "alert('Connection not established with server. Please check the network connection.');", true); return;
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Error", "alert('" + ex.Message.ToString().Replace("'", "''") + "');", true); return;
}
}
}
private void LoadDataInReportViewer(DataTable dtSetData)
{
try
{
if (dtSetData.Rows.Count > 0)
{
DataTable DataSetParameter = new DataTable();
DataSetParameter.Columns.Add("STATECODE");
DataSetParameter.Columns.Add("SiteCode");
DataSetParameter.Columns.Add("Cust_Group");
DataSetParameter.Columns.Add("Customer_Code");
DataSetParameter.Rows.Add();
string strStateCode = "";
string DistributorList = "";
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
}
else
{
foreach (ListItem item in chkListState.Items)
{
if (item.Selected)
{
if (strStateCode == "")
{
strStateCode += "" + item.Text.ToString() + "";
}
else
{
strStateCode += "," + item.Text.ToString() + "";
}
}
}
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (DistributorList == "")
{
DistributorList += "" + item.Text.ToString() + "";
}
else
{
DistributorList += "," + item.Text.ToString() + "";
}
}
}
}
if (strStateCode == string.Empty)
{
strStateCode = "ALL";
}
DataSetParameter.Rows[0]["STATECODE"] = strStateCode;
if (DistributorList == string.Empty)
{
DistributorList = "ALL";
}
DataSetParameter.Rows[0]["SiteCode"] = DistributorList;
string strCustomerGroup = "";
foreach (ListItem item in chkListCustomerGroup.Items)
{
if (item.Selected)
{
if (strCustomerGroup == "")
{
strCustomerGroup += "" + item.Text.ToString() + "";
}
else
{
strCustomerGroup += "," + item.Text.ToString() + "";
}
}
}
if (strCustomerGroup == string.Empty)
{
strCustomerGroup = "ALL";
}
DataSetParameter.Rows[0]["Cust_Group"] = strCustomerGroup;
string strCustomerName = "";
foreach (ListItem item in chkCustomerName.Items)
{
if (item.Selected)
{
if (strCustomerName == "")
{
strCustomerName += "" + item.Text.ToString() + "";
}
else
{
strCustomerName += "," + item.Text.ToString() + "";
}
}
}
if (strCustomerName == string.Empty)
{
strCustomerName = "ALL";
}
DataSetParameter.Rows[0]["Customer_Code"] = strCustomerName;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\CustomerOutstandingAgingReport.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 ActionResult CreateMatches()
{
var leaguename = "";
var cookie = Request.Cookies["leaguename"];
if (cookie != null)
{
leaguename = cookie.Value;
}
ViewBag.LeagueName = leaguename;
var leagueid = 0;
cookie = Request.Cookies["leagueid"];
if (cookie != null)
{
int.TryParse(cookie.Value, out leagueid);
}
var numOfWeeks = _db.Schedules.Count(x => x.Leagueid == leagueid);
var numofTeams = _db.Teams.Count(x => x.Leagueid == leagueid);
var missing = Missing(leagueid);
if (missing.Count > 0)
{
ViewBag.Error = "Some players not assigned to a team";
return(View(missing));
}
var complete = Complete(leagueid);
if (!complete)
{
ViewBag.Error = "Not all teams are complete";
return(View(missing));
}
var matches = _db.Matches.Where(x => x.Team.Leagueid == leagueid).ToList();
foreach (var match in matches)
{
if (match.Team1Score != 0 || match.Team2Score != 0 || match.ForFeitId != 0)
{
ViewBag.Error = "Matches cannot be delete, some matches have scores";
return(View(missing));
}
}
_db.Matches.RemoveRange(matches);
var cs = new CreateSchedule();
var newMatches = numofTeams % 2 == 0 ? cs.NoByes(numOfWeeks, numofTeams) : cs.Byes(numOfWeeks, numofTeams);
var scheduleList = _db.Schedules.Where(x => x.Leagueid == leagueid).ToList();
var lookup = new Dictionary <int, DateTime>();
int i = 1;
foreach (var item in scheduleList)
{
lookup[i++] = item.GameDate;
}
var teamList = _db.Teams.Where(x => x.Leagueid == leagueid).ToList();
foreach (var match in newMatches)
{
var team1 = teamList.Find(x => x.TeamNo == match.Team1 + 1);
var team2 = teamList.Find(x => x.TeamNo == match.Team2 + 1);
var date = lookup[match.Week + 1];
var round = scheduleList.Find(x => x.GameDate == date);
_db.Matches.Add(new Match()
{
id = 0,
WeekId = round.id,
Rink = match.Rink == -1 ? -1 : match.Rink + 1,
TeamNo1 = team1.id,
TeamNo2 = match.Rink == -1? (int?)null : team2.id,
Team1Score = 0,
Team2Score = 0,
ForFeitId = 0
});
}
try
{
_db.SaveChanges();
}
catch (Exception e)
{
ErrorSignal.FromCurrentContext().Raise(e);
ViewBag.Error = $"No matches were created, Error {e.Message}";
return(View(new List <Player>()));
}
var rounds = _db.Schedules.Where(x => x.Leagueid == leagueid);
if (!rounds.Any())
{
ViewBag.Error = "No matches created becuse no weeks have been scheduled";
return(View(missing));
}
return(RedirectToAction("index", new { weekid = rounds.First().id, id = leagueid }));
}
private Package CreatePackageFromNuGetPackage(PackageRegistration packageRegistration, IPackage nugetPackage)
{
var package = packageRegistration.Packages
.Where(pv => pv.Version == nugetPackage.Version.ToString())
.SingleOrDefault();
if (package != null)
{
switch (package.Status)
{
case PackageStatusType.Rejected:
throw new EntityException(
string.Format(
"This package has been {0} and can no longer be submitted.",
package.Status.GetDescriptionOrValue().ToLower()));
case PackageStatusType.Submitted:
//continue on
break;
default:
throw new EntityException(
"A package with identifier '{0}' and version '{1}' already exists.",
packageRegistration.Id,
package.Version);
}
}
var now = DateTime.UtcNow;
var packageFileStream = nugetPackage.GetStream();
//if new package versus updating an existing package.
if (package == null)
{
package = new Package();
}
package.Version = nugetPackage.Version.ToString();
package.Description = nugetPackage.Description;
package.ReleaseNotes = nugetPackage.ReleaseNotes;
package.RequiresLicenseAcceptance = nugetPackage.RequireLicenseAcceptance;
package.HashAlgorithm = Constants.Sha512HashAlgorithmId;
package.Hash = cryptoSvc.GenerateHash(packageFileStream.ReadAllBytes());
package.PackageFileSize = packageFileStream.Length;
package.Created = now;
package.Language = nugetPackage.Language;
package.LastUpdated = now;
package.Published = now;
package.Copyright = nugetPackage.Copyright;
package.IsPrerelease = !nugetPackage.IsReleaseVersion();
package.Listed = false;
package.Status = PackageStatusType.Submitted;
package.SubmittedStatus = PackageSubmittedStatusType.Ready;
package.ApprovedDate = null;
if (package.ReviewedDate.HasValue)
{
package.SubmittedStatus = PackageSubmittedStatusType.Updated;
}
//we don't moderate prereleases
if (package.IsPrerelease)
{
package.Listed = true;
package.Status = PackageStatusType.Exempted;
}
if (packageRegistration.IsTrusted)
{
package.Listed = true;
package.Status = PackageStatusType.Approved;
package.ReviewedDate = now;
package.ApprovedDate = now;
}
package.IconUrl = nugetPackage.IconUrl == null ? string.Empty : nugetPackage.IconUrl.ToString();
package.LicenseUrl = nugetPackage.LicenseUrl == null ? string.Empty : nugetPackage.LicenseUrl.ToString();
package.ProjectUrl = nugetPackage.ProjectUrl == null ? string.Empty : nugetPackage.ProjectUrl.ToString();
package.ProjectSourceUrl = nugetPackage.ProjectSourceUrl == null
? string.Empty
: nugetPackage.ProjectSourceUrl.ToString();
package.PackageSourceUrl = nugetPackage.PackageSourceUrl == null
? string.Empty
: nugetPackage.PackageSourceUrl.ToString();
package.DocsUrl = nugetPackage.DocsUrl == null ? string.Empty : nugetPackage.DocsUrl.ToString();
package.MailingListUrl = nugetPackage.MailingListUrl == null
? string.Empty
: nugetPackage.MailingListUrl.ToString();
package.BugTrackerUrl = nugetPackage.BugTrackerUrl == null ? string.Empty : nugetPackage.BugTrackerUrl.ToString();
package.Summary = nugetPackage.Summary ?? string.Empty;
package.Tags = nugetPackage.Tags ?? string.Empty;
package.Title = nugetPackage.Title ?? string.Empty;
foreach (var item in package.Authors.OrEmptyListIfNull().ToList())
{
packageAuthorRepo.DeleteOnCommit(item);
}
packageAuthorRepo.CommitChanges();
foreach (var author in nugetPackage.Authors)
{
package.Authors.Add(
new PackageAuthor
{
Name = author
});
}
foreach (var item in package.SupportedFrameworks.OrEmptyListIfNull().ToList())
{
packageFrameworksRepo.DeleteOnCommit(item);
}
packageFrameworksRepo.CommitChanges();
var supportedFrameworks = GetSupportedFrameworks(nugetPackage).Select(fn => fn.ToShortNameOrNull()).ToArray();
if (!supportedFrameworks.AnySafe(sf => sf == null))
{
foreach (var supportedFramework in supportedFrameworks)
{
package.SupportedFrameworks.Add(
new PackageFramework
{
TargetFramework = supportedFramework
});
}
}
foreach (var item in package.Dependencies.OrEmptyListIfNull().ToList())
{
packageDependenciesRepo.DeleteOnCommit(item);
}
packageDependenciesRepo.CommitChanges();
foreach (var dependencySet in nugetPackage.DependencySets)
{
if (dependencySet.Dependencies.Count == 0)
{
package.Dependencies.Add(
new PackageDependency
{
Id = null,
VersionSpec = null,
TargetFramework = dependencySet.TargetFramework.ToShortNameOrNull()
});
}
else
{
foreach (var dependency in dependencySet.Dependencies.Select(
d => new
{
d.Id,
d.VersionSpec,
dependencySet.TargetFramework
}))
{
package.Dependencies.Add(
new PackageDependency
{
Id = dependency.Id,
VersionSpec = dependency.VersionSpec == null ? null : dependency.VersionSpec.ToString(),
TargetFramework = dependency.TargetFramework.ToShortNameOrNull()
});
}
}
}
foreach (var item in package.Files.OrEmptyListIfNull().ToList())
{
packageFilesRepo.DeleteOnCommit(item);
}
packageFilesRepo.CommitChanges();
foreach (var packageFile in nugetPackage.GetFiles().OrEmptyListIfNull())
{
var filePath = packageFile.Path;
var fileContent = " ";
IList <string> extensions = new List <string>();
var approvedExtensions = Configuration.ReadAppSettings("PackageFileTextExtensions");
if (!string.IsNullOrWhiteSpace(approvedExtensions))
{
foreach (var extension in approvedExtensions.Split(',', ';'))
{
extensions.Add("." + extension);
}
}
IList <string> checksumExtensions = new List <string>();
var checksumApprovedExtensions = Configuration.ReadAppSettings("PackageFileChecksumExtensions");
if (!string.IsNullOrWhiteSpace(checksumApprovedExtensions))
{
foreach (var extension in checksumApprovedExtensions.Split(',', ';'))
{
checksumExtensions.Add("." + extension);
}
}
try
{
var extension = Path.GetExtension(filePath);
if (extension != null)
{
if (extensions.Contains(extension, StringComparer.InvariantCultureIgnoreCase))
{
fileContent = packageFile.GetStream().ReadToEnd();
}
else if (checksumExtensions.Contains(extension, StringComparer.InvariantCultureIgnoreCase))
{
var bytes = packageFile.GetStream().ReadAllBytes();
var md5Hash =
BitConverter.ToString(Convert.FromBase64String(cryptoSvc.GenerateHash(bytes, "MD5")))
.Replace("-", string.Empty);
var sha1Hash =
BitConverter.ToString(Convert.FromBase64String(cryptoSvc.GenerateHash(bytes, "SHA1")))
.Replace("-", string.Empty);
fileContent = string.Format("md5: {0} | sha1: {1}", md5Hash, sha1Hash);
}
}
} catch (Exception ex)
{
// Log but swallow the exception
ErrorSignal.FromCurrentContext().Raise(ex);
}
package.Files.Add(
new PackageFile
{
FilePath = filePath,
FileContent = fileContent,
});
}
package.FlattenedAuthors = package.Authors.Flatten();
package.FlattenedDependencies = package.Dependencies.Flatten();
return(package);
}
public ActionResult Scoring([Bind(Include = "id,WeekId,Rink,TeamNo1,TeamNo2,Team1Score,Team2Score,ForFeitId,rowversion")] Match match)
{
League league = null;
try
{
if (ModelState.IsValid)
{
var schedule = _db.Schedules.Find(match.WeekId);
if (schedule == null)
{
return(HttpNotFound());
}
league = schedule.League;
if (!league.TiesAllowed && match.Team1Score == match.Team2Score && match.ForFeitId == 0 && (match.Team1Score + match.Team2Score > 0))
{
ModelState.AddModelError(string.Empty, "Matched not scored, ties not allowed");
}
else
{
_db.Entry(match).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index", new { weekid = match.WeekId, id = league.id }));
}
}
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var clientValues = (Match)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
ModelState.AddModelError(string.Empty,
"Unable to save changes. The match was deleted by another user.");
}
else
{
var databaseValues = (Match)databaseEntry.ToObject();
if (databaseValues.Team1Score != clientValues.Team1Score)
{
ModelState.AddModelError("Team 1 Score", "Current value: "
+ databaseValues.Team1Score);
}
if (databaseValues.Team2Score != clientValues.Team2Score)
{
ModelState.AddModelError("Team 1 Score", "Current value: "
+ databaseValues.Team2Score);
}
if (databaseValues.ForFeitId != clientValues.ForFeitId)
{
ModelState.AddModelError("Forfeit", "Current value: "
+ databaseValues.ForFeitId);
}
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.");
match.rowversion = databaseValues.rowversion;
}
}
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);
}
var newmatch = _db.Matches.Find(match.id);
if (newmatch == null)
{
return(HttpNotFound());
}
newmatch.Team1Score = match.Team1Score;
newmatch.Team2Score = match.Team2Score;
newmatch.ForFeitId = match.ForFeitId;
var forfeits = new List <SelectListItem>
{
new SelectListItem {
Value = "0", Text = "No Forfeit", Selected = match.ForFeitId == 0
},
new SelectListItem
{
Value = newmatch.Team.TeamNo.ToString(),
Text = $"Team No. {newmatch.Team.TeamNo}",
Selected = match.ForFeitId == newmatch.Team.TeamNo
},
new SelectListItem
{
Value = newmatch.Team1.TeamNo.ToString(),
Text = $"Team No. {newmatch.Team1.TeamNo}",
Selected = match.ForFeitId == newmatch.Team1.TeamNo
}
};
ViewBag.TeamSize = newmatch.Schedule.League.TeamSize;
ViewBag.ForFeitId = forfeits;
ViewBag.Id = newmatch.Schedule.Leagueid;
return(View(newmatch));
}
public static UserValidationResult AuthenticateLogon(string userName, string password, string url, CMSDataContext db)
{
var userQuery = db.Users.Where(uu =>
uu.Username == userName ||
uu.Person.EmailAddress == userName ||
uu.Person.EmailAddress2 == userName
);
var impersonating = false;
User user = null;
var userExists = false;
try
{
userExists = userQuery.Any();
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
return(UserValidationResult.Invalid(UserValidationStatus.BadDatabase, "bad database"));
}
var failedPasswordCount = 0;
foreach (var u in userQuery.ToList())
{
if (u.TempPassword != null && password == u.TempPassword)
{
u.TempPassword = null;
if (password == "bvcms") // set this up so Admin/bvcms works until password is changed
{
u.Password = "";
u.MustChangePassword = true;
}
else
{
var mu = CMSMembershipProvider.provider.GetUser(userName, false);
mu?.UnlockUser();
CMSMembershipProvider.provider.AdminOverride = true;
mu?.ChangePassword(mu.ResetPassword(), password);
CMSMembershipProvider.provider.AdminOverride = false;
u.MustChangePassword = true;
}
u.IsLockedOut = false;
db.SubmitChanges();
user = u;
break;
}
if (password == db.Setting("ImpersonatePassword", Guid.NewGuid().ToString()))
{
user = u;
impersonating = true;
HttpContextFactory.Current.Session["IsNonFinanceImpersonator"] = "true";
break;
}
if (CMSMembershipProvider.provider.ValidateUser(u.Username, password))
{
db.Refresh(RefreshMode.OverwriteCurrentValues, u);
user = u;
break;
}
failedPasswordCount = Math.Max(failedPasswordCount, u.FailedPasswordAttemptCount);
}
return(ValidateUserBeforeLogin(db, userName, url, user, userExists, failedPasswordCount, impersonating));
}
private void Addloadsheetheader()
{
string productcode1;
int recid;
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
conn = obj.GetConnection();
adp1 = new SqlDataAdapter("SELECT Top (1) recid FROM ax.ACXLOADSHEETHEADER order by recid desc ", conn);
ds2.Clear();
adp1.Fill(ds2, "dtl");
if (ds2.Tables["dtl"].Rows.Count != 0)
{
productcode1 = string.Copy(ds2.Tables["dtl"].Rows[0][0].ToString());
recid = Convert.ToInt32((productcode1).ToString()) + 1;
}
else
{
recid = 1;
}
SqlTransaction transaction;
transaction = conn.BeginTransaction();
int k = 0;
try
{
SqlCommand comm = new SqlCommand();
SqlCommand comm1 = new SqlCommand();
SqlCommand comm2 = new SqlCommand();
SqlDataAdapter sqladp = new SqlDataAdapter();
DataTable dt = new DataTable();
string sono = "";
//string strLoadSheetNo = obj.GetNumSequence(5, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString());
DataTable dtNumSeq = obj.GetNumSequenceNew(5, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString()); //st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yyMMddhhmmss");
string strLoadSheetNo = string.Empty;
string NUMSEQ = string.Empty;
if (dtNumSeq != null)
{
strLoadSheetNo = dtNumSeq.Rows[0][0].ToString();
NUMSEQ = dtNumSeq.Rows[0][1].ToString();
}
else
{
return;
}
bool flag = false;
string lodNO = string.Empty;
for (int i = 0; i < gvDetails.Rows.Count; i++)
{
if (((CheckBox)gvDetails.Rows[i].FindControl("chkStatus")).Checked)
{
sono = ((CheckBox)gvDetails.Rows[i].FindControl("chkStatus")).Text;
string sodate = gvDetails.Rows[i].Cells[1].Text;
string customergroup = gvDetails.Rows[i].Cells[2].Text;
string customercode = gvDetails.Rows[i].Cells[3].Text;
string psrname = gvDetails.Rows[i].Cells[6].Text;
string beatname = gvDetails.Rows[i].Cells[8].Text;
string deliverydate = gvDetails.Rows[i].Cells[10].Text;
string value = gvDetails.Rows[i].Cells[11].Text;
string sitecode1, DataAreaId;
sitecode1 = Session["SiteCode"].ToString();
DataAreaId = Session["DATAAREAID"].ToString();
decimal value1;
value1 = Convert.ToDecimal(value);
comm = new SqlCommand("ax.ACX_ACXLOADSHEETHEADER", conn, transaction);
comm.CommandType = CommandType.StoredProcedure;
comm.CommandTimeout = 0;
comm.Parameters.AddWithValue("@SITEID", sitecode1);
comm.Parameters.AddWithValue("@DATAAREAID", DataAreaId);
comm.Parameters.AddWithValue("@RECID", i + recid);
comm.Parameters.AddWithValue("@CUSTOMER_CODE", customercode);
comm.Parameters.AddWithValue("@LOADSHEET_NO", strLoadSheetNo);
lodNO = strLoadSheetNo;
comm.Parameters.AddWithValue("@SO_NO", sono);
comm.Parameters.AddWithValue("@SO_DATE", sodate);
comm.Parameters.AddWithValue("@PSR_CODE", psrname);
comm.Parameters.AddWithValue("@PSR_BEAT", beatname);
comm.Parameters.AddWithValue("@INVOICE_DATE", deliverydate);
comm.Parameters.AddWithValue("@DELIVERY_DATE", deliverydate);
comm.Parameters.AddWithValue("@VALUE", value1);
comm.Parameters.AddWithValue("@RATE", value1);
comm.Parameters.AddWithValue("@NUMSEQ", NUMSEQ);
int a1 = comm.ExecuteNonQuery();
string box = ""; decimal box2;
for (int j = 0; j < GridView2.Rows.Count; j++)
{
string productgroup = GridView2.Rows[j].Cells[0].Text;
string productcode = GridView2.Rows[j].Cells[1].Text;
string crate = GridView2.Rows[j].Cells[3].Text;
TextBox txtBox = ((TextBox)GridView2.Rows[j].FindControl("txtqty")); //with conv
TextBox txtPcs = ((TextBox)GridView2.Rows[j].FindControl("txtPCS")); //pcs
TextBox txtBoxQty = ((TextBox)GridView2.Rows[j].FindControl("txtBox")); //box qty
TextBox txtBoxPcs = ((TextBox)GridView2.Rows[j].FindControl("txtBoxPcs")); // boxpcs
box = txtBox.Text;
string Ltr = GridView2.Rows[j].Cells[8].Text;
string stockBox = GridView2.Rows[j].Cells[9].Text;
string StockLtr = GridView2.Rows[j].Cells[10].Text;
string sitecode2, DataAreaId2, uom;
uom = "";
sitecode2 = Session["SiteCode"].ToString();
DataAreaId2 = Session["DATAAREAID"].ToString();
decimal crate1, ltr1, stockBox1, StockLtr1;
stockBox1 = Convert.ToDecimal(stockBox);
StockLtr1 = Convert.ToDecimal(StockLtr);
crate1 = Convert.ToDecimal(crate);
box2 = Convert.ToDecimal(box);
ltr1 = Convert.ToDecimal(Ltr);
if (Convert.ToDecimal(txtBox.Text) <= Convert.ToDecimal(stockBox) && Convert.ToDecimal(txtBox.Text) > 0)
{
comm1 = new SqlCommand("ax.ACX_ACXLOADSHEETLINE", conn, transaction);
comm1.CommandType = CommandType.StoredProcedure;
comm1.CommandTimeout = 0;
comm1.Parameters.AddWithValue("@SHITEID", sitecode2);
comm1.Parameters.AddWithValue("@DATAAREAID", DataAreaId2);
comm1.Parameters.AddWithValue("@RECID", j + 1 + recid);
comm1.Parameters.AddWithValue("@CUSTOMER_CODE", customercode);
comm1.Parameters.AddWithValue("@LOADSHEET_NO", strLoadSheetNo);
comm1.Parameters.AddWithValue("@LINE_NO", j + 1);
comm1.Parameters.AddWithValue("@UOM", uom);
comm1.Parameters.AddWithValue("@STOCKQTY_BOX", stockBox1);
comm1.Parameters.AddWithValue("@STOCKQTY_LTR", StockLtr1);
comm1.Parameters.AddWithValue("@BOX", box2);
comm1.Parameters.AddWithValue("@CRATES", crate1);
comm1.Parameters.AddWithValue("@LINENUM", j + 1);
comm1.Parameters.AddWithValue("@LTR", ltr1);
comm1.Parameters.AddWithValue("@PRODUCT_CODE", productcode);
comm1.Parameters.AddWithValue("@BOXQty", Convert.ToDecimal(txtBoxQty.Text.Trim()));
comm1.Parameters.AddWithValue("@PcsQty", Convert.ToDecimal(txtPcs.Text.Trim()));
comm1.Parameters.AddWithValue("@BOXPcs", txtBoxPcs.Text.Trim());
int a = comm1.ExecuteNonQuery();
}
}
for (k = 0; k < gvDetails.Rows.Count; k++)
{
if (((CheckBox)gvDetails.Rows[k].FindControl("chkStatus")).Checked)
{
sono = ((CheckBox)gvDetails.Rows[k].FindControl("chkStatus")).Text;
sitecode1 = Session["SiteCode"].ToString();
DataAreaId = Session["DATAAREAID"].ToString();
comm2 = new SqlCommand("ax.ACX_ACXLOADSHEETHEADERUPDATE_LOADNO", conn, transaction);
comm2.CommandType = CommandType.StoredProcedure;
comm2.Parameters.AddWithValue("@LOADSHEET_NO", strLoadSheetNo);
comm2.Parameters.AddWithValue("@SO_NO", sono);
comm2.Parameters.AddWithValue("@SiteCode", sitecode1);
comm2.Parameters.AddWithValue("@DATAAREAID", DataAreaId);
int a2 = comm2.ExecuteNonQuery();
}
}
//obj.UpdateLastNumSequence(5, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString(), conn, transaction);
transaction.Commit();
flag = true;
break;
}
}
if (flag == true)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Load Sheet N0:" + lodNO + " generated Suucessfull!');", true);
Session["LSNO"] = lodNO;
}
}
catch (Exception ex)
{
transaction.Rollback();
conn.Close();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (drptargetType.SelectedValue.ToString() == "3")
{
SavePSRStipend();
}
else
{
DataTable dtExpense = new DataTable();
if (Session["DistributorExpense"] == null)
{
dtExpense = GetData(Convert.ToDateTime(txtFromDate.Text));
}
else
{
dtExpense = (DataTable)Session["DistributorExpense"];
}
SqlConnection con = baseObj.GetConnection();
SqlTransaction tran = null;
SqlCommand cmd = new SqlCommand();
SqlCommand cmd1 = new SqlCommand();
try
{
DataTable dt = baseObj.GetNumSequenceNew(11, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString()); //st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yyMMddhhmmss");
string Doc_NO = string.Empty;
string NUMSEQ = string.Empty;
if (dt != null)
{
Doc_NO = dt.Rows[0][0].ToString();
NUMSEQ = dt.Rows[0][1].ToString();
}
else
{
return;
}
//Generate Document Number Seq for VRS Claim Setup
dt = baseObj.GetNumSequenceNew(17, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString()); //st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yyMMddhhmmss");
string Doc_NO_Claim = string.Empty;
string NUMSEQ_Claim = string.Empty;
if (dt != null)
{
Doc_NO_Claim = dt.Rows[0][0].ToString();
NUMSEQ_Claim = dt.Rows[0][1].ToString();
}
if (con.State.ToString() == "Closed")
{
con.Open();
}
tran = con.BeginTransaction();
cmd.Transaction = tran;
Boolean FoundAlready, FoundSuccess;
FoundAlready = false;
FoundSuccess = false;
if (!dtExpense.Columns.Contains("STATUS"))
{
dtExpense.Columns.Add("STATUS", typeof(string));
}
//foreach (GridViewRow grv in grvDetail.Rows)
for (int i = 0; i < dtExpense.Rows.Count; i++)
{
string OBJECT_CODE = dtExpense.Rows[i]["DISTRIBUTOR CODE"].ToString();
string OBJECT_SUBCODE = "";
string FROM_DATE = "", TO_DATE = "";
string TARGET = "0";
string ACHIVEMENT = "0";
string TARGET_INCENTIVE = "";
string ACTUAL_INCENTIVE = dtExpense.Rows[i]["EXPENSE AMOUNT"].ToString();
string CLAIM_CATEGORY = dtExpense.Rows[i]["CATEGORY"].ToString();
string CLAIM_SUBCATEGORY = dtExpense.Rows[i]["EXPENSECODE"].ToString();
string STATUS = "0";
string MODIFIEDDATETIME = string.Empty;
string CREATEDDATETIME = string.Empty;
string TARGET_GROUP = "";
string CALCULATION_PATTERN = "";
string CLAIM_MONTH = "";
string BUCODE = "";
//string VALUE_PER = "0";// dtExpense.Rows[i]["AMOUNT%"].ToString(); ;
//string FIXED_AMT = "0"; //dtExpense.Rows[i]["FIXED AMT"].ToString(); ;
//string FIXED_PER_DAY = "0"; //dtExpense.Rows[i]["FIXED PER DAY"].ToString(); ;
string PRESENT_DAYS = "0"; //dtExpense.Rows[i]["PRESENT DAYS"].ToString(); ;
string VDCLAIM_TYPE = "1";
string VALUE_PER = "0"; // dtExpense.Rows[i]["AMOUNT%"].ToString(); ;
string FIXED_AMT = "0"; // dtExpense.Rows[i]["FIXED AMT"].ToString(); ;
string FIXED_PER_DAY = "0"; // dtExpense.Rows[i]["FIXED PER DAY"].ToString();
CLAIM_MONTH = FROM_DATE = Convert.ToDateTime("01 " + txtFromDate.Text).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(FROM_DATE).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
if (drptargetType.SelectedValue.ToString() == "1")
{
TARGET_INCENTIVE = dtExpense.Rows[i]["CALCULATE ON"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["EXPENSE ON"].ToString();
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "2")
{
OBJECT_SUBCODE = dtExpense.Rows[i]["CUSTGROUP"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
CLAIM_MONTH = Convert.ToDateTime(txtFromDate.Text).ToString("yyyy-MM-01");
TARGET_INCENTIVE = dtExpense.Rows[i]["INCENTIVE VALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "4")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["INCENTIVE VALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "5")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["FIXVALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "6")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["FIXED AMT"].ToString();
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "7")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
//TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["FIXVALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString();
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
VDCLAIM_TYPE = "2";
PRESENT_DAYS = dtExpense.Rows[i]["PRESENT DAYS"].ToString();
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "8")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["FIXVALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
VDCLAIM_TYPE = "3";
PRESENT_DAYS = dtExpense.Rows[i]["PRESENT DAYS"].ToString();
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "9")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["FIXVALUE"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
VDCLAIM_TYPE = "4";
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
}
if (drptargetType.SelectedValue.ToString() == "10")
{
OBJECT_CODE = dtExpense.Rows[i]["VRS CODE"].ToString();
OBJECT_SUBCODE = dtExpense.Rows[i]["VENDORCODE"].ToString();
FROM_DATE = Convert.ToDateTime(dtExpense.Rows[i]["FROMDATE"]).ToString("yyyy-MM-dd");
TO_DATE = Convert.ToDateTime(dtExpense.Rows[i]["TODATE"]).ToString("yyyy-MM-dd");
TARGET = dtExpense.Rows[i]["TARGET"].ToString();
ACHIVEMENT = dtExpense.Rows[i]["ACHIVEMENT"].ToString();
TARGET_INCENTIVE = dtExpense.Rows[i]["VALUE%"].ToString();
CALCULATION_PATTERN = dtExpense.Rows[i]["CALCULATION ON"].ToString().ToUpper() == "FIX" ? "0" : "1";
TARGET_GROUP = dtExpense.Rows[i]["INCENTIVE ON"].ToString().ToUpper() == "VALUE" ? "0" : "1";
BUCODE = dtExpense.Rows[i]["BUCODE"].ToString();
VDCLAIM_TYPE = "5";
}
VALUE_PER = dtExpense.Columns.Contains("AMOUNT%") == true?dtExpense.Rows[i]["AMOUNT%"].ToString():"0";
if (dtExpense.Columns.Contains("FIXED AMT"))
{
FIXED_AMT = dtExpense.Rows[i]["FIXED AMT"].ToString();
}
else if (dtExpense.Columns.Contains("FIXVALUE"))
{
FIXED_AMT = dtExpense.Rows[0]["FIXVALUE"].ToString();
}
else
{
FIXED_AMT = "0";
}
FIXED_PER_DAY = dtExpense.Columns.Contains("FIXED PER DAY") == true ? dtExpense.Rows[i]["FIXED PER DAY"].ToString() : "0";
string EXP_TYPE = dtExpense.Rows[i]["TARGET TYPE"].ToString();
if (EXP_TYPE == "SALE")
{
EXP_TYPE = "1";
}
else if (EXP_TYPE == "PURCHASE")
{
EXP_TYPE = "2";
}
else
{
EXP_TYPE = "0";
}
string sqlstr = @"SELECT * FROM [ax].[ACX_VRSCLAIMMASTER] where SITE_CODE='" + Session["SiteCode"].ToString() + "' and FROM_DATE='" + FROM_DATE + "' ";
sqlstr += "and TO_DATE='" + TO_DATE + "' and VRS_CODE='" + OBJECT_CODE + "' AND EXP_TYPE='" + EXP_TYPE + "' and VD_SUBCODE='" + OBJECT_SUBCODE + "' ";
sqlstr += "and TARGET=" + TARGET + " and CLAIM_CATEGORY='" + CLAIM_CATEGORY + "' and CLAIM_SUBCATEGORY='" + CLAIM_SUBCATEGORY + "' and DATAAREAID='" + Session["DATAAREAID"] + "' and [INCENTIVE_ON]='" + TARGET_GROUP + "'";
dt = baseObj.GetData(sqlstr);
if (dt.Rows.Count == 0)
{
if (Convert.ToDouble(ACTUAL_INCENTIVE) > 0)
{
#region SAVE ON VRS CLAIM TABLE
//===================New===============
if (OBJECT_CODE.Trim().Length > 0)
{
if (TARGET_GROUP == "VALUE" || TARGET_GROUP == "")
{
TARGET_GROUP = "0";
}
else if (TARGET_GROUP == "LTR")
{
TARGET_GROUP = "1";
}
if (CALCULATION_PATTERN == "FIX")
{
CALCULATION_PATTERN = "0";
}
else
{
CALCULATION_PATTERN = "1";
}
cmd1 = new SqlCommand("ACXINSERTCLAIMMASTER_MONTHLY");
cmd1.Connection = con;
cmd1.Parameters.Clear();
cmd1.Transaction = tran;
cmd1.CommandTimeout = 3600;
cmd1.CommandType = CommandType.StoredProcedure;
string sqlstr1 = @"SELECT * FROM ax.ACX_VRSClaimMaster where SITE_CODE='" + Session["SiteCode"].ToString() + "' and FROM_DATE='" + FROM_DATE + "' ";
sqlstr1 += "and TO_DATE='" + TO_DATE + "' and VRS_CODE='" + OBJECT_CODE + "' and VD_SUBCODE='" + OBJECT_SUBCODE + "' and CLAIM_CATEGORY='" + CLAIM_CATEGORY + "' and CLAIM_SUBCATEGORY='" + CLAIM_SUBCATEGORY + "' and DATAAREAID='" + Session["DATAAREAID"] + "' ";
dt = baseObj.GetData(sqlstr1);
if (dt.Rows.Count == 0)
{
if (Convert.ToDouble(ACTUAL_INCENTIVE) > 0)
{
cmd1.Parameters.Add("@DATAAREAID", SqlDbType.NVarChar).Value = Session["DATAAREAID"];
cmd1.Parameters.Add("@DOCUMENT_CODE", SqlDbType.NVarChar).Value = Doc_NO_Claim;
cmd1.Parameters.Add("@SITE_CODE", SqlDbType.NVarChar).Value = Session["SiteCode"].ToString();
cmd1.Parameters.Add("@VRS_CODE", SqlDbType.NVarChar).Value = OBJECT_CODE;
cmd1.Parameters.Add("@VD_SUBCODE", SqlDbType.NVarChar).Value = OBJECT_SUBCODE;
cmd1.Parameters.Add("@FROM_DATE", SqlDbType.DateTime).Value = FROM_DATE;
cmd1.Parameters.Add("@TO_DATE", SqlDbType.DateTime).Value = TO_DATE;
cmd1.Parameters.Add("@EXP_TYPE", SqlDbType.Int).Value = EXP_TYPE;
cmd1.Parameters.Add("@INCENTIVE_ON", SqlDbType.Int).Value = TARGET_GROUP;
cmd1.Parameters.Add("@CALCULATION_ON", SqlDbType.Int).Value = CALCULATION_PATTERN;
cmd1.Parameters.Add("@TARGET", SqlDbType.Decimal).Value = TARGET;
cmd1.Parameters.Add("@ACHIVEMENT", SqlDbType.Decimal).Value = ACHIVEMENT;
cmd1.Parameters.Add("@VALUE_PER", SqlDbType.Decimal).Value = VALUE_PER;
cmd1.Parameters.Add("@FIXED_AMT", SqlDbType.Decimal).Value = FIXED_AMT;
cmd1.Parameters.Add("@FIXED_PER_DAY", SqlDbType.Decimal).Value = FIXED_PER_DAY;
cmd1.Parameters.Add("@PRESENT_DAYS", SqlDbType.Int).Value = PRESENT_DAYS;
cmd1.Parameters.Add("@ACTUAL_INCENTIVE", SqlDbType.Decimal).Value = ACTUAL_INCENTIVE;
cmd1.Parameters.Add("@CLAIM_CATEGORY", SqlDbType.NVarChar).Value = CLAIM_CATEGORY;
cmd1.Parameters.Add("@CLAIM_SUBCATEGORY", SqlDbType.NVarChar).Value = CLAIM_SUBCATEGORY;
cmd1.Parameters.Add("@CLAIM_TYPE", SqlDbType.NVarChar).Value = VDCLAIM_TYPE;
cmd1.Parameters.Add("@STATUS", SqlDbType.Int).Value = STATUS;
cmd1.Parameters.Add("@NumSeq", SqlDbType.BigInt).Value = NUMSEQ_Claim;
cmd1.Parameters.Add("@CLAIM_MONTH", SqlDbType.SmallDateTime).Value = CLAIM_MONTH;
cmd1.Parameters.Add("@BUCODE", SqlDbType.NVarChar).Value = BUCODE;
cmd1.ExecuteNonQuery();
DataRow[] dr = dtExpense.Select("[EXPENSECODE]='" + CLAIM_SUBCATEGORY + "'");
if (dr.Length > 0)
{
for (int j = 0; j < dr.Length; j++)
{
dr[j]["STATUS"] = "Success";
}
}
}
}
}
#endregion
}
} //IF END
else
{
FoundAlready = true;
//if (drptargetType.SelectedValue.ToString() == "1")
//{
DataRow[] dr = dtExpense.Select("[EXPENSECODE]='" + CLAIM_SUBCATEGORY + "'");
if (dr.Length > 0)
{
for (int j = 0; j < dr.Length; j++)
{
dr[j]["STATUS"] = "Already";
}
}
//}
}
} //FOR END
tran.Commit();
if (FoundAlready == true && FoundSuccess == true)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Some data already saved. Except that saved successfully.');", true);
grvDetail.DataSource = dtExpense;
grvDetail.DataBind();
return;
}
else if (FoundAlready)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data already saved.');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data saved successfully.');", true);
}
grvDetail.DataSource = null;
grvDetail.Visible = false;
// grvDetail.Columns[22].Visible = true;
}
catch (Exception ex)
{
tran.Rollback();
lblError.Text = ex.Message;
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { if (con.State.ToString() == "Open")
{
con.Close();
}
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { }
}
protected void txtQtyBox_TextChanged(object sender, EventArgs e) //This for calculate Qty value,Crate and Ltr for sale Line
{
try
{
GridViewRow gvrow = (GridViewRow)(((TextBox)sender)).NamingContainer;
TextBox txtBox = (TextBox)gvrow.FindControl("txtBox");
TextBox txtPCS = (TextBox)gvrow.FindControl("txtPCS");
TextBox txtQty = (TextBox)gvrow.FindControl("txtqty"); //total Qty conv
TextBox txtBoxPcs = (TextBox)gvrow.FindControl("txtBoxPcs"); //total Qty conv
HiddenField productPack = (HiddenField)gvrow.FindControl("HiddenField2");
if (txtBox.Text == "")
{
txtBox.Text = "0";
}
if (txtPCS.Text == "")
{
txtPCS.Text = "0";
}
if (Convert.ToDecimal(txtPCS.Text) > Convert.ToDecimal(productPack.Value))
{
int pcs = Convert.ToInt32(Convert.ToDecimal(txtPCS.Text));
int pac = Convert.ToInt32(Convert.ToDecimal(productPack.Value));
int addbox = pcs / pac;
int remainder = pcs % pac;
if (remainder == 0)
{
txtPCS.Text = "0";
}
else
{
txtPCS.Text = Convert.ToString(remainder);
}
txtBox.Text = Convert.ToString(Convert.ToInt32(Convert.ToDouble(txtBox.Text)) + addbox);
}
if (txtBox.Text != "" && txtPCS.Text != "")
{
string str = (Convert.ToInt32(txtBox.Text) + (Convert.ToDecimal(txtPCS.Text) / Convert.ToDecimal(productPack.Value))).ToString("N6");
txtQty.Text = str;
}
DataTable dt = new DataTable();
dt = baseObj.GetData("SELECT BOXPRINT FROM [dbo].[udf_GetPCSDetails](" + App_Code.Global.ConvertToDecimal(txtQty.Text).ToString() + "," + Convert.ToDecimal(productPack.Value) + ")");
if (dt.Rows.Count > 0)
{
txtBoxPcs.Text = dt.Rows[0][0].ToString();
}
string[] calValue = baseObj.CalculatePrice1(gvrow.Cells[1].Text, string.Empty, decimal.Parse(txtQty.Text), "Box");
if (calValue.Length > 0)
{
gvrow.Cells[3].Text = calValue[0]; //Crate
gvrow.Cells[8].Text = calValue[1]; //ltr
}
if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(gvrow.Cells[9].Text))
{
gvrow.BackColor = System.Drawing.Color.Red;
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please check stock Qty for ITEM:" + gvrow.Cells[1].Text + " !');", true);
txtQty.Text = "0";
gvrow.Cells[3].Text = "0";
gvrow.Cells[8].Text = "0";
}
else
{
gvrow.BackColor = System.Drawing.Color.White;
}
ltr = 0;
Crates = 0;
BoxQty = 0;
TotalQtyConv = 0;
PcsQty = 0;
foreach (GridViewRow grv in GridView2.Rows)
{
string str = grv.Cells[3].Text;
Crates += Convert.ToDecimal(grv.Cells[3].Text);
TextBox txtQtyConv = (TextBox)grv.Cells[6].FindControl("txtqty");
TotalQtyConv += Convert.ToDecimal(txtQtyConv.Text);
TextBox txtBoxQty = (TextBox)grv.Cells[4].FindControl("txtBox");
BoxQty += Convert.ToDecimal(txtBoxQty.Text);
TextBox txtPcsQty = (TextBox)grv.Cells[5].FindControl("txtPCS");
PcsQty += Convert.ToDecimal(txtPcsQty.Text);
ltr += Convert.ToDecimal(grv.Cells[8].Text);
}
GridView2.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[2].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[2].Text = "TOTAL : ";
GridView2.FooterRow.Cells[2].Font.Bold = true;
GridView2.FooterRow.Cells[3].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[3].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[3].Text = Crates.ToString();
GridView2.FooterRow.Cells[3].Font.Bold = true;
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;
GridView2.FooterRow.Cells[5].Text = PcsQty.ToString();
GridView2.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[5].Font.Bold = true;
GridView2.FooterRow.Cells[6].Text = TotalQtyConv.ToString();
GridView2.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[6].Font.Bold = true;
GridView2.FooterRow.Cells[8].HorizontalAlign = HorizontalAlign.Right;
GridView2.FooterRow.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue;
GridView2.FooterRow.Cells[8].Text = ltr.ToString();
GridView2.FooterRow.Cells[8].Font.Bold = true;
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Input String was not in Correct format !');", true);
}
//UppnalegridDetails.Update();
}
private DataTable GetData(DateTime fromdate)
{
DataTable dt = null;
try
{
SqlConnection con = baseObj.GetConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = string.Empty;
cmd.CommandType = CommandType.StoredProcedure;
if (drptargetType.SelectedValue.ToString() == "1")
{
cmd.CommandText = "ACX_TARGET_DISTRIBUTOREXPENSE";
}
if (drptargetType.SelectedValue.ToString() == "2")
{
cmd.CommandText = "ACX_TARGET_ANNUALEXPENSE";
}
if (drptargetType.SelectedValue.ToString() == "3")
{
cmd.CommandText = "ACX_GETPSRSTIPEND";
}
if (drptargetType.SelectedValue.ToString() == "4")
{
cmd.CommandText = "ACX_TARGET_VRSEXPENSE";
}
if (drptargetType.SelectedValue.ToString() == "5")
{
cmd.CommandText = "ACX_TARGET_VRSEXPENSE1";
}
if (drptargetType.SelectedValue.ToString() == "6")
//{ cmd.CommandText = "ACX_TARGET_VRSCLAIMSETUP"; }
{
cmd.CommandText = "ACX_TARGET_VRSCLAIMSETUP_MONTHLY";
}
if (drptargetType.SelectedValue.ToString() == "7")
{
cmd.CommandText = "ACX_TARGET_VDEXPENSE2";
}
if (drptargetType.SelectedValue.ToString() == "8")
{
cmd.CommandText = "ACX_TARGET_VDEXPENSE3";
}
if (drptargetType.SelectedValue.ToString() == "9")
{
cmd.CommandText = "ACX_TARGET_VDEXPENSE4";
}
if (drptargetType.SelectedValue.ToString() == "10")
{
cmd.CommandText = "ACX_TARGET_VDEXPENSE5";
}
cmd.Parameters.Add("@EXPENSEMONTH", SqlDbType.SmallDateTime).Value = fromdate.ToString("yyyy-MM-01");
cmd.Parameters.Add("@SiteId", SqlDbType.NVarChar).Value = Convert.ToString(Session["SiteCode"]);
cmd.Parameters.Add("@BUCode", SqlDbType.NVarChar).Value = ddlBusinessUnit.SelectedItem.Value;
// cmd.Parameters.Add("@VRSCODE", SqlDbType.NVarChar).Value = Convert.ToString(Session["SiteCode"]);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
dt = new DataTable();
ad.Fill(dt);
return(dt);
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
return(dt);
}
}
/// <summary>
/// Method executed <b>after</b> the body of methods to which this aspect is applied,
/// in case that the method resulted with an exception (i.e., in a <c>catch</c> block).
/// </summary>
/// <param name="args">Advice arguments.</param>
public override sealed void OnException(MethodExecutionArgs args)
{
ErrorSignal.FromCurrentContext().Raise(args.Exception);
args.FlowBehavior = FlowBehavior.ThrowException;
base.OnException(args);
}
protected void SavePSRStipend()
{
SqlConnection conn = null;
SqlCommand cmd;
try
{
conn = baseObj.GetConnection();
string strCode = string.Empty;
cmd = new SqlCommand();
transaction = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = transaction;
cmd.CommandTimeout = 3600;
cmd.CommandText = string.Empty;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ACX_Insert_PSRSTIPEND";
Boolean FoundAlready, FoundSuccess;
FoundAlready = false;
FoundSuccess = false;
int count = 0;
foreach (GridViewRow grv in gvDetailsPSRStipend.Rows)
{
cmd.Parameters.Clear();
string PSRCODE = grv.Cells[0].Text;
string SITEID = Session["SITECODE"].ToString();
string EMPLOYEENO = grv.Cells[2].Text;
decimal CONTRIBUTION = Convert.ToDecimal(grv.Cells[3].Text);
decimal TA = Convert.ToDecimal(grv.Cells[4].Text);
decimal DA = Convert.ToDecimal(grv.Cells[5].Text);
decimal MOBILE = Convert.ToDecimal(grv.Cells[6].Text);
decimal TOTALSTIPEND = 0;// Convert.ToDecimal(grv.Cells[7].Text);
decimal ACTUALSTIPEND = 0;
if (grv.Cells[10].Text != "")
{
ACTUALSTIPEND = Convert.ToDecimal(grv.Cells[10].Text);
}
TextBox txtSTIPENDWORKIGDAYS = (TextBox)grv.FindControl("txtStipendDays");
TextBox txtTADAWORKIGDAYS = (TextBox)grv.FindControl("txtTADADays");
decimal STIPENDWORKIGDAYS = Convert.ToDecimal(txtSTIPENDWORKIGDAYS.Text);
decimal TADAWORKIGDAYS = Convert.ToDecimal(txtTADAWORKIGDAYS.Text);
string stipendmnth = Convert.ToDateTime(txtFromDate.Text).ToString("yyyy-MM-dd");
string sqlstr = @"SELECT * FROM [ax].[ACXPSRSTIPEND] where siteid='" + SITEID + "' and psrcode ='" + PSRCODE + "' and stipendmonth='" + stipendmnth + "' ";
DataTable dt = baseObj.GetData(sqlstr);
if (dt.Rows.Count == 0)
{
if (ACTUALSTIPEND > 0)
{
count = count + 1;
cmd.Parameters.AddWithValue("@SITEID", SITEID);
cmd.Parameters.AddWithValue("@PSRCODE", PSRCODE);
cmd.Parameters.AddWithValue("@EMPLOYEENO", EMPLOYEENO);
cmd.Parameters.AddWithValue("@MONTHSTIPEND", Convert.ToDateTime(txtFromDate.Text));
cmd.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString());
cmd.Parameters.AddWithValue("@CONTRIBUTION", CONTRIBUTION);
cmd.Parameters.AddWithValue("@TA", TA);
cmd.Parameters.AddWithValue("@DA", DA);
cmd.Parameters.AddWithValue("@MOBILE", MOBILE);
cmd.Parameters.AddWithValue("@TOTALSTIPEND", TOTALSTIPEND);
cmd.Parameters.AddWithValue("@ACTUALSTIPEND", ACTUALSTIPEND);
cmd.Parameters.AddWithValue("@STIPENDWORKIGDAYS", STIPENDWORKIGDAYS);
cmd.Parameters.AddWithValue("@TADAWORKIGDAYS", TADAWORKIGDAYS);
cmd.ExecuteNonQuery();
FoundSuccess = true;
}
}
else
{
FoundAlready = true;
}
}
transaction.Commit();
if (FoundAlready == true && FoundSuccess == true)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Some data already saved. Except that saved successfully.');", true);
}
else if (FoundAlready)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data already saved.');", true);
}
else if (count == 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data not saved.');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data saved successfully.');", true);
}
//ScriptManager.RegisterStartupScript(this, typeof(Page), "Information", "alert('Data saved successfully.');", true);
gvDetailsPSRStipend.DataSource = null;
gvDetailsPSRStipend.Visible = false;
btnsave.Visible = false;
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
transaction.Rollback();
string message = "alert('Error:" + ex.Message + " !');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true);
}
finally { if (conn.State.ToString() == "Open")
{
conn.Close();
}
}
}
public ActionResult OnePageGiving(PaymentForm pf)
{
if (!Util.ValidEmail(pf.Email))
{
ModelState.AddModelError("Email", "Need a valid email address");
}
if (pf.AmtToPay == 0)
{
ModelState.AddModelError("AmtToPay", "Invalid Amount");
}
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, pf.OrgId, pf.testing, null, null, pf.source)
{
URL = "/OnePageGiving/" + pf.OrgId
};
SetHeaders(m);
SetInstructions(m);
var p = m.List[0];
if (pf.ShowCampusOnePageGiving)
{
pf.Campuses = p.Campuses().ToList();
}
if (!ModelState.IsValid)
{
return(View("OnePageGiving/Index", pf));
}
if (CheckAddress(pf) == false)
{
return(View("OnePageGiving/Index", pf));
}
pf.ValidatePaymentForm(ModelState, shouldValidateBilling: false);
if (!ModelState.IsValid)
{
return(View("OnePageGiving/Index", 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;
if (pf.ShowCampusOnePageGiving)
{
p.Campus = pf.CampusId.ToString();
}
pf.State = pf.State;
p.IsNew = p.person == null;
if (pf.testing)
{
pf.CheckTesting();
}
var id = pf.OrgId;
if (id == null)
{
return(Message("Missing OrgId"));
}
if (pf.Country.HasValue() && !pf.Zip.HasValue())
{
pf.Zip = "NA";
}
var ti = pf.ProcessPaymentTransaction(m);
if (pf.Zip == "NA")
{
pf.Zip = null;
}
var fundid = m.settings[id.Value].DonationFundId ?? 0;
p.FundItem.Add(fundid, pf.AmtToPay);
var ret = m.ConfirmTransaction(ti);
switch (ret.Route)
{
case RouteType.ModelAction:
if (ti.Approved == true)
{
TempData["onlineregmodel"] = Util.Serialize(m);
return(Redirect("/OnePageGiving/ThankYou"));
}
ErrorSignal.FromCurrentContext().Raise(new Exception(ti.Message));
ModelState.AddModelError("TranId", ti.Message);
return(View("OnePageGiving/Index", pf));
case RouteType.Error:
DbUtil.Db.LogActivity("OnePageGiving Error " + ret.Message, pf.OrgId);
return(Message(ret.Message));
default: // unexptected Route
ErrorSignal.FromCurrentContext().Raise(new Exception("OnePageGiving Unexpected route"));
DbUtil.Db.LogActivity("OnlineReg Unexpected Route " + ret.Message, pf.OrgId);
ModelState.AddModelError("TranId", "unexpected error in payment processing");
return(View(ret.View ?? "OnePageGiving/Index", pf));
}
}
public ActionResult Edit([Bind(Include = "id,GameDate,Leagueid,Cancelled,rowversion")] Schedule schedule)
{
try
{
if (ModelState.IsValid)
{
if (db.Schedules.Any(x => x.GameDate == schedule.GameDate && x.id != schedule.id))
{
ModelState.AddModelError(string.Empty, "Duplicate date is not allowed");
}
else
{
db.Entry(schedule).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { id = schedule.Leagueid }));
}
}
}
catch (DbUpdateConcurrencyException ex)
{
var entry = ex.Entries.Single();
var clientValues = (Schedule)entry.Entity;
var databaseEntry = entry.GetDatabaseValues();
if (databaseEntry == null)
{
ModelState.AddModelError(string.Empty,
"Unable to save changes. The schedule record was deleted by another user.");
}
else
{
var databaseValues = (Schedule)databaseEntry.ToObject();
if (databaseValues.WeekDate != clientValues.WeekDate)
{
ModelState.AddModelError("Game Date", "Current value: "
+ databaseValues.GameDate.ToShortDateString());
}
if (databaseValues.Cancelled != clientValues.Cancelled)
{
ModelState.AddModelError("Cancelled", "Current value: "
+ databaseValues.Cancelled);
}
if (databaseValues.Leagueid != clientValues.Leagueid)
{
ModelState.AddModelError("League", "Current value: "
+ databaseValues.Leagueid);
}
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.");
schedule.rowversion = databaseValues.rowversion;
}
}
catch (Exception dex)
{
while (dex.InnerException != null)
{
dex = dex.InnerException;
}
//Log the error (uncomment dex variable name and add a line here to write a log.)
ModelState.AddModelError("",
$"Unable to save changes. {dex.Message}");
ErrorSignal.FromCurrentContext().Raise(dex);
}
ViewBag.Schedule = db.Schedules.Where(x => x.Leagueid == schedule.Leagueid).OrderBy(x => x.GameDate);
return(View(schedule));
}
private void ShowReportSaleInvoice_New(DataTable dtHeader, DataTable dtLinetest, string strIdSavePDF)
{
try
{
decimal GlobalTaxAmount = 0;
DataTable dtAmountWords = null;
DataTable dtLine = new DataTable();
CreamBell_DMS_WebApps.App_Code.AmountToWords obj1 = new AmountToWords();
decimal TotalAmount = 0;
string InvoiceNo = dtHeader.Rows[0]["INVOICE_NO"].ToString();
if (dtLinetest.Rows.Count > 0)
{
dtLine.Columns.Add("SRNO"); dtLine.Columns.Add("PRODUCT_CODE"); dtLine.Columns.Add("PRODUCT_NAME"); dtLine.Columns.Add("PRODUCT_PACKSIZE");
dtLine.Columns.Add("BOX"); dtLine.Columns.Add("BoxConv"); dtLine.Columns.Add("MRP"); dtLine.Columns.Add("RATE"); dtLine.Columns.Add("LTR");
dtLine.Columns.Add("TAX_CODE"); dtLine.Columns.Add("CRATES"); dtLine.Columns.Add("AMOUNT");
dtLine.Columns.Add("TAX_AMOUNT"); dtLine.Columns.Add("LINEAMOUNT"); dtLine.Columns.Add("DISC_AMOUNT"); dtLine.Columns.Add("SEC_DISC_AMOUNT");
dtLine.Columns.Add("ADDTAX_AMOUNT");
dtLine.Columns.Add("ADDTAX_CODE"); dtLine.Columns.Add("PEValue");
dtLine.Columns.Add("TDValue");
dtLine.Columns.Add("TaxableAmt");
dtLine.Columns.Add("basic");
h1 = new HashSet <string>();
for (int i = 0; i < dtLinetest.Rows.Count; i++)
{
if (!h1.Contains(dtLinetest.Rows[i]["TAX_CODE"].ToString()))
{
h1.Add(dtLinetest.Rows[i]["TAX_CODE"].ToString());
}
dtLine.Rows.Add();
dtLine.Rows[i]["SRNO"] = dtLinetest.Rows[i]["SRNO"].ToString();
dtLine.Rows[i]["PRODUCT_CODE"] = dtLinetest.Rows[i]["PRODUCT_CODE"].ToString();
dtLine.Rows[i]["PRODUCT_NAME"] = dtLinetest.Rows[i]["PRODUCT_NAME"].ToString();
dtLine.Rows[i]["PRODUCT_PACKSIZE"] = dtLinetest.Rows[i]["PRODUCT_PACKSIZE"];
dtLine.Rows[i]["BOX"] = Convert.ToDecimal(dtLinetest.Rows[i]["BOX"]);
dtLine.Rows[i]["BoxConv"] = Convert.ToDecimal(dtLinetest.Rows[i]["BoxConv"]);
dtLine.Rows[i]["MRP"] = Convert.ToDecimal(dtLinetest.Rows[i]["MRP"]);
dtLine.Rows[i]["RATE"] = Convert.ToDecimal(dtLinetest.Rows[i]["RATE"]);
dtLine.Rows[i]["LTR"] = Convert.ToDecimal(dtLinetest.Rows[i]["LTR"]);
dtLine.Rows[i]["TAX_CODE"] = Convert.ToDecimal(dtLinetest.Rows[i]["TAX_CODE"]);
dtLine.Rows[i]["CRATES"] = Convert.ToDecimal(dtLinetest.Rows[i]["CRATES"]);
dtLine.Rows[i]["AMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["AMOUNT"]);
dtLine.Rows[i]["TAX_AMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["TAX_AMOUNT"]);
GlobalTaxAmount += Convert.ToDecimal(dtLinetest.Rows[i]["TAX_AMOUNT"]);
dtLine.Rows[i]["LINEAMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["LINEAMOUNT"]);
dtLine.Rows[i]["DISC_AMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["DISC_AMOUNT"]);
dtLine.Rows[i]["ADDTAX_AMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["ADDTAX_AMOUNT"]);
dtLine.Rows[i]["SEC_DISC_AMOUNT"] = Convert.ToDecimal(dtLinetest.Rows[i]["SEC_DISC_AMOUNT"]);
dtLine.Rows[i]["ADDTAX_CODE"] = Convert.ToDecimal(dtLinetest.Rows[i]["ADDTAX_CODE"]);
dtLine.Rows[i]["PEValue"] = Convert.ToDecimal(dtLinetest.Rows[i]["PEValue"]);
dtLine.Rows[i]["TDValue"] = Convert.ToDecimal(dtLinetest.Rows[i]["TDValue"]);
dtLine.Rows[i]["TaxableAmt"] = Convert.ToDecimal(dtLinetest.Rows[i]["TaxableAmt"]);
dtLine.Rows[i]["basic"] = Convert.ToDecimal(dtLinetest.Rows[i]["basic"]);
TotalAmount += Convert.ToDecimal(dtLinetest.Rows[i]["AMOUNT"]);
}
//decimal HeaderAmount = Convert.ToDecimal(dtHeader.Rows[0]["INVOICE_VALUE"].ToString());//
decimal HeaderAmount = TotalAmount;
decimal TotalTaxAmount = GlobalTaxAmount; //dtLine.AsEnumerable().Sum(row => row.Field<decimal>("TAX_AMOUNT"));
//decimal TotalTaxAmount = 12 ;
decimal TotalNetValue = HeaderAmount; // +TotalTaxAmount; //Math.Round(HeaderAmount + TotalTaxAmount);
//---Calculating Round Off Value for the Sale Invoice Bill---//
decimal RoundOffValue = 0;
decimal FinalValueForWords = 0;
double decimalpoints = Convert.ToDouble(Math.Abs(TotalNetValue - Math.Floor(TotalNetValue)));
if (decimalpoints > 0.5)
{
RoundOffValue = (decimal)Math.Round(TotalNetValue);
FinalValueForWords = RoundOffValue; //+ Convert.ToDecimal(decimalpoints);
decimalpoints = 1 - decimalpoints; // if Rounding Value is greater than 0.50 then plus sign with decimal points.
}
else
{
decimalpoints = 0 - decimalpoints; // if Rounding Value is less than 0.50 then negative sign with decimal points.
RoundOffValue = (decimal)Math.Floor(TotalNetValue);
FinalValueForWords = RoundOffValue;
}
if (dtLinetest.Rows.Count > 0)
{
// h1.Remove("0.00"); //----For Finding the different TAX AMOUNT CODE----//
int TaxCodeCount = (h1.Count) * 2; //--- Count the TAX_CODE rows----//
int dtlinecount = dtLine.Rows.Count + 6 + TaxCodeCount; //---6 is for FOOTER ROWS COUNTS [TOTAL]---//
int totalrec = dtlinecount % 41;
if ((dtLinetest.Rows.Count > 41 && dtLinetest.Rows.Count < 49) || (totalrec > 0 && totalrec <= 8))
{
totalrec = dtlinecount % 32;
int totalcount = 32 - totalrec; ///------Total Rows on a single page is 25
if (totalrec != 0)
{
for (int i = 0; i < totalcount; i++) // -For adding the empty rows in a report.
{
DataRow dr = dtLine.NewRow();
dr[0] = ""; dr[1] = ""; dr[2] = "";
dr[3] = 0; dr[4] = 0; dr[5] = 0; dr[6] = 0;
dr[7] = 0; dr[8] = 0; dr[9] = 0; dr[10] = 0;
dr[11] = 0; dr[12] = 0; dr[13] = 0;
dr[14] = 0; dr[15] = 0; dr[16] = 0;
dr[17] = 0; dr[18] = 0; dr[19] = 0; dr[20] = 0; dr[21] = 0;
dtLine.Rows.InsertAt(dr, dtLine.Rows.Count + 1);
}
}
string Words = obj1.words(Convert.ToInt32(FinalValueForWords));
string queryAmountWords = "Select INVOICE_VALUE , '" + Words + "' as AMNTWORDS, " + decimalpoints + " as RoundOffValue from ax.ACXSALEINVOICEHEADER where INVOICE_NO='" + dtLinetest.Rows[0]["Invoice_No"].ToString() + "' and SITEID='" + Session["SiteCode"].ToString() + "'";
dtAmountWords = obj.GetData(queryAmountWords);
ReportViewer1.AsyncRendering = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource RDS1 = new ReportDataSource("DSetHeader", dtHeader);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource RDS2 = new ReportDataSource("DSetLine", dtLine);
ReportViewer1.LocalReport.DataSources.Add(RDS2);
ReportDataSource RDS3 = new ReportDataSource("DSetAmountWords", dtAmountWords);
ReportViewer1.LocalReport.DataSources.Add(RDS3);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\SaleInvoice.rdl");
ReportViewer1.ShowPrintButton = true;
}
else
{
totalrec = dtlinecount % 41;
int totalcount = 41 - totalrec; ///------Total Rows on a single page is 25
if (totalrec != 0)
{
for (int i = 0; i <= totalcount; i++) //-For adding the empty rows in a report.
{
DataRow dr = dtLine.NewRow();
dr[0] = ""; dr[1] = ""; dr[2] = "";
dr[3] = 0; dr[4] = 0; dr[5] = 0; dr[6] = 0;
dr[7] = 0; dr[8] = 0; dr[9] = 0; dr[10] = 0;
dr[11] = 0; dr[12] = 0; dr[13] = 0;
dr[14] = 0; dr[15] = 0; dr[16] = 0;
dr[17] = 0; dr[18] = 0; dr[19] = 0; dr[20] = 0; dr[21] = 0;
dtLine.Rows.InsertAt(dr, dtLine.Rows.Count + 1);
}
}
string Words = obj1.words(Convert.ToInt32(FinalValueForWords));
string queryAmountWords = "Select INVOICE_VALUE , '" + Words + "' as AMNTWORDS, " + decimalpoints + " as RoundOffValue from ax.ACXSALEINVOICEHEADER where INVOICE_NO='" + dtLinetest.Rows[0]["Invoice_No"].ToString() + "' and SITEID='" + Session["SiteCode"].ToString() + "'";
dtAmountWords = obj.GetData(queryAmountWords);
ReportViewer1.AsyncRendering = true;
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportDataSource RDS1 = new ReportDataSource("DSetHeader", dtHeader);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(RDS1);
ReportDataSource RDS2 = new ReportDataSource("DSetLine", dtLine);
ReportViewer1.LocalReport.DataSources.Add(RDS2);
ReportDataSource RDS3 = new ReportDataSource("DSetAmountWords", dtAmountWords);
ReportViewer1.LocalReport.DataSources.Add(RDS3);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Reports\\SaleInvoice1.rdl");
ReportViewer1.ShowPrintButton = true;
}
}
}
ReportViewer1.LocalReport.DisplayName = dtLinetest.Rows[0]["Invoice_No"].ToString();
//ReportViewer1.LocalReport.Refresh();
//UpdatePanel1.Update();
#region generate PDF of ReportViewer
string savePath = Server.MapPath("Downloads\\" + strIdSavePDF + ".pdf");
byte[] Bytes = ReportViewer1.LocalReport.Render(format: "PDF", deviceInfo: "");
using (FileStream stream = new FileStream(savePath, FileMode.Create))
{
stream.Write(Bytes, 0, Bytes.Length);
}
//Warning[] warnings;
//string[] streamIds;
//string mimeType = string.Empty;
//string encoding = string.Empty;
//string extension = string.Empty;
//byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
//bytelist.Add(Bytes);
#endregion
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
private void WriteElmahException(Exception ex)
{
var elmahCon = ErrorSignal.FromCurrentContext();
elmahCon.Raise(ex);
}
public void Log(Exception exception)
{
Trace.TraceError(exception.ToString());
ErrorSignal.FromCurrentContext().Raise(exception);
}
protected void BtnShowReport0_Click(object sender, EventArgs e)
{
try
{
bool b = Validate();
if (b)
{
if (!string.IsNullOrEmpty(txt30.Text.Trim()))
{
Int64 strAge30 = Convert.ToInt64(txt30.Text.Trim());
if (strAge30 > 30)
{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Please enter valid age range!')", true);
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please enter valid age range!');", true);
txt30.Focus();
return;
}
}
if (!string.IsNullOrEmpty(txt60.Text.Trim()))
{
Int64 strAge60 = Convert.ToInt64(txt60.Text.Trim());
if (strAge60 > 60)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please enter valid age range!');", true);
txt60.Focus();
return;
}
}
if (!string.IsNullOrEmpty(txt90.Text.Trim()))
{
Int64 strAge90 = Convert.ToInt64(txt90.Text.Trim());
if (strAge90 > 90)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please enter valid age range!');", true);
txt120.Focus();
return;
}
}
if (!string.IsNullOrEmpty(txt120.Text.Trim()))
{
Int64 strAge120 = Convert.ToInt64(txt120.Text.Trim());
if (strAge120 > 120)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please enter valid age range!');", true);
txt120.Focus();
return;
}
}
if (!string.IsNullOrEmpty(txtOver120.Text.Trim()))
{
Int64 strAgeOver120 = Convert.ToInt64(txtOver120.Text.Trim());
if (strAgeOver120 < 120)
{
this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Please enter valid age range!');", true);
txtOver120.Focus();
return;
}
}
ShowReportByFilter();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
