protected void grvInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
var dll = (DropDownList)e.Row.FindControl("ddlInvoiceOrAdvNo");
if (ViewState["ddlInvoiceOrAdvNo"] == null)
{
var inv = new AdvAdjustmentBLL().GetInvoiceFromJob(ddlJobNo.SelectedValue.IntRequired(), rdoDbCr.SelectedValue[0], 'N');
ViewState["ddlInvoiceOrAdvNo"] = inv;
}
DataSet ds = (DataSet)ViewState["ddlInvoiceOrAdvNo"];
dll.DataSource = ds;
dll.DataTextField = "InvoiceNo";
dll.DataValueField = "pk_InvoiceID";
dll.DataBind();
dll.Items.Insert(0, new ListItem("--Select--", "0"));
List <InvoiceJobAdjustment> lstInvoiceJobAdjustment = (List <InvoiceJobAdjustment>)ViewState["InvoiceJobAdjustment"];
if (lstInvoiceJobAdjustment != null && lstInvoiceJobAdjustment.Count > 0)
{
foreach (var v in lstInvoiceJobAdjustment)
{
try
{
dll.Items.Remove(dll.Items.FindByValue(v.InvoiceOrAdvNo));
}
catch { }
}
}
}
else if (e.Row.RowType == DataControlRowType.DataRow && IsEmptyGrid)
{
e.Row.Visible = false;
IsEmptyGrid = false;
}
}
private void LoadData(int id)
{
var src = new AdvAdjustmentBLL().GetAdjustmentModel(new SearchCriteria {
StringParams = new List <string>()
{
id.ToString(), "", "", "J", "", ""
}
});
if (src != null && src.Count() > 0)
{
var model = src.FirstOrDefault();
ddlJobNo.SelectedValue = model.JobNo;
ddlJobNo_SelectIndexChange(null, null);
txtAdjustmentDate.Text = model.AdjustmentDate.ToShortDateString();
rdoDbCr.SelectedValue = model.DOrC;
rdoDbCr_SelectIndexChange(null, null);
ddlDrCrName.SelectedValue = model.DebtorOrCreditorName;
lblAdjustmentId.Text = model.AdjustmentNo.ToString();
txtAdjustmentDate.Enabled = false;
rdoDbCr.Enabled = false;
ddlJobNo.Enabled = false;
ddlDrCrName.Enabled = false;
ddlAdjustmentNo.Items.Insert(0, new ListItem(model.AdvanceNo, model.AdvanceID.ToString()));
//ddlAdjustmentNo.SelectedValue = model.AdvanceID.ToString();
ddlAdjustmentNo.SelectedIndex = 0;
ddlAdjustmentNo_SelectedIndexChanged(null, null);
var inv = new AdvAdjustmentBLL().GetInvoiceFromJob(ddlJobNo.SelectedValue.IntRequired(), model.DOrC[0], 'N');
ViewState["ddlInvoiceOrAdvNo"] = inv;
if (model.LstInvoiceJobAdjustment != null && model.LstInvoiceJobAdjustment.Count > 0)
{
if (ViewState["ddlInvoiceOrAdvNo"] != null)
{
DataSet ds = (DataSet)ViewState["ddlInvoiceOrAdvNo"];
foreach (var v in model.LstInvoiceJobAdjustment)
{
DataRow row = ds.Tables[0].AsEnumerable().Where(x => Convert.ToString(x["InvoiceNo"]).Equals(v.InvoiceOrAdvNo)).FirstOrDefault();
if (row != null)
{
v.InvoiceOrAdvDate = Convert.ToDateTime(Convert.ToString(row["InvoiceDate"]));
}
}
}
}
ViewState["InvoiceJobAdjustment"] = model.LstInvoiceJobAdjustment;
grvInvoice.DataSource = model.LstInvoiceJobAdjustment;
grvInvoice.DataBind();
}
}
private void SaveAdjustmentModel()
{
var data = ExtractData();
if (IsValid(data.LstInvoiceJobAdjustment, data.DOrC, lblAdjustmentAmt.Text.ToDouble()))
{
var result = new AdvAdjustmentBLL().SaveAdjustmentModel(data, Mode);
if (result > 0)
{
// AdvAdjInvID = result;
Response.Redirect("~/Forwarding/Transaction/ManageAdvanceAdjustment.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.Ticks.ToString(), "alert('Error Occured');", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), DateTime.Now.Ticks.ToString(), "alert('Avance and Invoice are not properly adjusted.');", true);
}
}
private void SetEmptyGrid()
{
grvInvoice.ShowFooter = true;
IsEmptyGrid = true;
List <InvoiceJobAdjustment> dr = new List <InvoiceJobAdjustment>()
{
new InvoiceJobAdjustment {
}
};
grvInvoice.DataSource = dr;
grvInvoice.DataBind();
ViewState["InvoiceJobAdjustment"] = new List <InvoiceJobAdjustment>();
DataSet inv = new AdvAdjustmentBLL().GetUnadjustedAdvances(ddlJobNo.SelectedValue.IntRequired(), rdoDbCr.SelectedValue[0], ddlDrCrName.SelectedValue.ToInt());
//DataSet ds = (DataSet)ViewState["ddlInvoiceOrAdvNo"];
ddlAdjustmentNo.DataSource = inv;
ddlAdjustmentNo.DataTextField = "pmtReference";
ddlAdjustmentNo.DataValueField = "pk_AdvanceID";
ddlAdjustmentNo.DataBind();
ddlAdjustmentNo.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void LoadDefault()
{
var jobs = new AdvAdjustmentBLL().GetDetailFromJob();
ddlJobNo.DataSource = jobs;
ddlJobNo.DataTextField = "JobNo";
ddlJobNo.DataValueField = "pk_JobID";
ddlJobNo.DataBind();
ddlJobNo.Items.Insert(0, new ListItem("--Select--", "0"));
ViewState["Jobs"] = jobs;
var temp = new List <InvoiceJobAdjustment>();
grvInvoice.DataSource = temp;
grvInvoice.DataBind();
ViewState["InvoiceJobAdjustment"] = temp;
//grvInvoice.ShowFooter = false;
ddlDrCrName.Enabled = false;
txtAdjustmentDate.Text = DateTime.Now.ToShortDateString();
lblAdjustmentId.Text = "Auto Generated Id";
lblAdjustmentAmt.Text = "";
lblJobDate.Text = "";
rdoDbCr.Enabled = false;
}
protected void ddlAdjustmentNo_SelectedIndexChanged(object sender, EventArgs e)
{
var Adv = new AdvAdjustmentBLL().GetAdvaneDetail(ddlAdjustmentNo.SelectedValue.ToInt());
lblAdjustmentAmt.Text = (Adv.Tables[0].Rows[0]["ChequePayment"].ToDecimal() + Adv.Tables[0].Rows[0]["ChequePayment"].ToDecimal()).ToString();
}
