private void Populate(Int64 stckid)
{
OpenTyreDAL objMast = new OpenTyreDAL();
StckMast objStckMast = objMast.SelectById(stckid);
if (objStckMast != null)
{
var VarStckDetl = objMast.SelectDetlById(Convert.ToInt64(objStckMast.Item_Idno), Convert.ToInt64(objStckMast.Loc_Idno));
if (VarStckDetl != null && VarStckDetl.Count > 0)
{
for (int i = 0; i < VarStckDetl.Count; i++)
{
ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Loc_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialNo")));
}
ViewState["dt"] = dtTemp;
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
ddlItemName.Enabled = false;
ddlLocation.Enabled = false;
ddlItemName.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Item_Idno"));
ddlLocation.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Loc_Idno"));
}
else
{
ddlItemName.Enabled = true;
ddlLocation.Enabled = true;
}
this.BindGridT();
}
}
objMast = null;
}
private void FetchRecords()
{
Int64 YearIdno = Convert.ToInt64(ddlDateRange.SelectedValue);
Int64 LocIdno = ddlLocation.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlLocation.SelectedValue);
Int64 ItemIdno = ddlItemName.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlItemName.SelectedValue);
OpenAccDAL objMast = new OpenAccDAL();
var Mast = objMast.SelectStckMast(YearIdno, LocIdno, ItemIdno);
if (Mast != null && Mast.Count > 0)
{
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp.Rows.Count > 0)
{
dtTemp = null;
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
}
for (int i = 0; i < Mast.Count; i++)
{
ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(Mast[i], "YearIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "LocIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "LocName")), Convert.ToString(DataBinder.Eval(Mast[i], "ItemIdno")), Convert.ToString(DataBinder.Eval(Mast[i], "ItemName")), string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(Mast[i], "Qty"))) == true ? "0" : Convert.ToString(DataBinder.Eval(Mast[i], "Qty")), string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(Mast[i], "Rate"))) == true ? "0.00" : Convert.ToString(DataBinder.Eval(Mast[i], "Rate")));
}
ViewState["dt"] = dtTemp;
dtTemp = (DataTable)ViewState["dt"];
this.BindGridT();
}
else
{
dtTemp = null;
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
grdMain.DataSource = dtTemp;
grdMain.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DtTemp = (DataTable)ViewState["dt"];
string msg = string.Empty;
if (txtReceivedAmount.Text == string.Empty)
{
this.ShowMessage("Please enter Received Amount!");
return;
}
else if (txtSummaryNo.Text == string.Empty)
{
this.ShowMessage("Please enter Summary No!");
return;
}
else
{
if (txtReceivedAmount.Text == string.Empty || txtReceivedAmount.Text == "0")
{
this.ShowMessage("Received Amount must be greater than 0!");
return;
}
else if (txtSummaryNo.Text == string.Empty || txtSummaryNo.Text == "0")
{
this.ShowMessage(" Summary No must be greater than 0!");
return;
}
}
if (Hidrowid.Value != string.Empty)
{
DtTemp = (DataTable)ViewState["dt"];
foreach (DataRow dtrow in DtTemp.Rows)
{
if (Convert.ToString(dtrow["id"]) == Convert.ToString(Hidrowid.Value))
{
dtrow["Sumry_No"] = txtSummaryNo.Text;
dtrow["Recvng_Date"] = txtRecDate.Text;
dtrow["Recvng_Amnt"] = txtReceivedAmount.Text;
dtrow["Remark"] = txtRemark.Text;
}
}
}
else
{
if (DtTemp == null)
{
DtTemp = CreateDt();
}
int id = DtTemp.Rows.Count == 0 ? 1 : DtTemp.Rows.Count + 1;
ApplicationFunction.DatatableAddRow(DtTemp, id,
txtSummaryNo.Text, txtRecDate.Text, txtReceivedAmount.Text, txtRemark.Text);
ViewState["dt"] = DtTemp;
}
this.BindGrid();
this.ClearItems();
}
public DataTable ReadExcelFile(string fileName)
{
string msg = string.Empty;
DataTable dt = new DataTable();
string filepath = Server.MapPath(fileName);
string constring = string.Empty;
if (System.IO.Path.GetExtension(filepath) == ".xls")
{
constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filepath + "';Extended Properties='Excel 8.0;HDR=Yes;'";
}
else if (System.IO.Path.GetExtension(filepath) == ".xlsx")
{
constring = "Provider= Microsoft.ACE.OLEDB.12.0;OLE DB Services=-4;Data Source='" + filepath + "'; Extended Properties=\"Excel 12.0;HDR=YES;\"";
}
if (string.IsNullOrEmpty(constring) == false)
{
OleDbConnection con = new OleDbConnection(constring);
con.Open();
DataTable ExcelTable = new DataTable();
ExcelTable = con.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = Convert.ToString(ExcelTable.Rows[0][2]);
OleDbDataAdapter da = new OleDbDataAdapter("select * from [" + SheetName + "]", con);
DataSet ds = new DataSet();
da.Fill(ds);
dt = ApplicationFunction.CreateTable("tblOpngStckAccessoriesFromExcel", "Item", "String", "Qty", "String", "Rate", "String");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Columns[0].Caption == "Item" && ds.Tables[0].Columns[1].Caption == "Qty" && ds.Tables[0].Columns[2].Caption == "Rate")
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int count = 0; count < ds.Tables[0].Rows.Count; count++)
{
ApplicationFunction.DatatableAddRow(dt,
Convert.ToString(ds.Tables[0].Rows[count]["Item"]),
Convert.ToString(ds.Tables[0].Rows[count]["Qty"]),
Convert.ToString(ds.Tables[0].Rows[count]["Rate"])
);
}
}
else
{
ShowMessageErr("Excel Is Blank.Please Upload With Data.");
}
}
else
{
this.ShowMessageErr("Excel Header Not In Correct Format.");
}
}
else
{
ShowMessageErr("Please Check Excel File Columns!");
}
}
return(dt);
}
protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
if (txtCalimNo.Text == "" && ddlDivPrtyName.SelectedValue == "0")
{
DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Claim Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return;
}
else
{
grdSearchRecords.Visible = true;
MaterialIssueAgnClaimDAL objMaterialIssueAgnClaimDAL = new MaterialIssueAgnClaimDAL();
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtCalimNo.Text.Trim())) ? "" : Convert.ToString(txtCalimNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()));
var lst = objMaterialIssueAgnClaimDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objMaterialIssueAgnClaimDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string HeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "HeadIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "HeadIdno")));
string HeadDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "HeadDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "HeadDate")).ToString("dd-MM-yyyy"));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string PrtyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrtyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrtyName"));
string FromCityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "FromCityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "FromCityName"));
string CompName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CompName"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "CompName"));
//string CompIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CompIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "CompIdno"));
//string FromCityIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "FromCityIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "FromCityIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, HeadIdno, ApplicationFunction.mmddyyyy(HeadDate), (PrefNo + "" + ClaimNumber), PrtyName, FromCityName, CompName);
}
HidHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "HeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[0], "HeadIdno"));
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PrtyIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[0], "PrtyIdno"));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
public void FetchRec()
{
OpenTyreDAL objMast = new OpenTyreDAL();
Int64 YearIdno = Convert.ToInt64(ddlDateRange.SelectedValue);
Int64 LocIdno = ddlLocation.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlLocation.SelectedValue);
Int64 ItemIdno = ddlItemName.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddlItemName.SelectedValue);
Int64 tyresizeIdno = ddltyresize.SelectedIndex == 0 ? 0 : Convert.ToInt64(ddltyresize.SelectedValue);
//hidstckidno.Value = Convert.ToString(Mast.SerlDetl_id);
var VarStckDetl = objMast.SelectDetlByItemIdno(YearIdno, LocIdno, ItemIdno, tyresizeIdno);
if (VarStckDetl != null && VarStckDetl.Count > 0)
{
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp.Rows.Count > 0)
{
dtTemp = null;
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
}
for (int i = 0; i < VarStckDetl.Count; i++)
{
int type = Convert.ToInt32(DataBinder.Eval(VarStckDetl[i], "ItemType")) - 1;
ApplicationFunction.DatatableAddRow(dtTemp, i + 1, Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialNo")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "CompName")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "ItemType")), Convert.ToString(ddltype.Items[type].Text), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "PurFrom")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "OpenRate")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Name")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "Item_Idno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "SerialIdno")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "TyreSize")), Convert.ToString(DataBinder.Eval(VarStckDetl[i], "TyreSizeIdno")));
}
ViewState["dt"] = dtTemp;
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
ddlItemName.Enabled = true;
ddlLocation.Enabled = true;
// ddlItemName.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Item_Idno"));
//ddlLocation.SelectedValue = Convert.ToString(DataBinder.Eval(VarStckDetl[0], "Loc_Idno"));
}
else
{
ddlItemName.Enabled = true;
ddlLocation.Enabled = true;
}
this.BindGridT();
}
else
{
dtTemp = null;
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
grdMain.DataSource = dtTemp;
grdMain.DataBind();
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
dtTemp = (DataTable)ViewState["dt"];
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
dtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = dtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
txtSerialNo.Text = Convert.ToString(drs[0]["SerialNo"]);
txtCompName.Text = Convert.ToString(drs[0]["CompName"]);
ddltype.SelectedValue = Convert.ToString(drs[0]["TypeId"]);
ddltyresize.SelectedValue = string.IsNullOrEmpty(Convert.ToString(drs[0]["tyresizeidno"]))? "0" : Convert.ToString(drs[0]["tyresizeidno"]);
txtPurchaseFrom.Text = Convert.ToString(drs[0]["PurFrom"]);
txtOpenRate.Text = Convert.ToString(drs[0]["OpenRate"]);
//ddlItemName.SelectedValue = Convert.ToString(drs[0]["ItemIdno"]);
ViewState["ID"] = Convert.ToString(drs[0]["id"]);
ddlItemName.Enabled = false; rfvPartno.Enabled = false;
}
}
else if (e.CommandName == "cmddelete")
{
//DataTable dtInnerDelete = CreateDt();
DataTable objDataTable = CreateDt();
// dtTemp = (DataTable)ViewState["dt"];
dtDelete = (DataTable)ViewState["dtDelete"];
foreach (DataRow rw in dtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["SerialNo"], rw["CompName"], rw["TypeId"], rw["Type"], rw["PurFrom"], rw["OpenRate"], rw["TyreName"], rw["TyreIdno"], rw["TyreSize"], rw["TyreSizeIdno"]);
}
else
{
ApplicationFunction.DatatableAddRow(dtDelete, rw["id"], rw["SerialNo"], rw["CompName"], rw["TypeId"], rw["Type"], rw["PurFrom"], rw["OpenRate"], rw["TyreName"], rw["TyreIdno"], rw["TyreSize"], rw["TyreSizeIdno"]);
}
}
ViewState["dtDelete"] = dtDelete;
ViewState["dt"] = objDataTable;
objDataTable.Dispose();
this.BindGridT();
}
}
//protected void lnkbtnNew_OnClick(object sender, EventArgs e)
//{
// ClearItems();
//}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtCommsision.Text == "")
{
txtCommsision.Text = "0.00";
}
int Id = 1;
txtCommsision.Text = Convert.ToDouble(txtCommsision.Text).ToString("N2");
if (Convert.ToDouble(txtCommsision.Text) > 0)
{
if (grdMain.Rows.Count > 0)
{
DtTemp = CreateDt();
int a = grdMain.PageIndex;
for (int i = 0; i < grdMain.PageCount; i++)
{
grdMain.SetPageIndex(i);
foreach (GridViewRow dr in grdMain.Rows)
{
HiddenField hidTocity_Idno = (HiddenField)dr.FindControl("hidTocity_Idno");
TextBox txtCommissionAmnt = (TextBox)dr.FindControl("txtCommissionAmnt");
Label lblCityName = (Label)dr.FindControl("lblCityName");
txtCommissionAmnt.Text = Convert.ToDouble(txtCommsision.Text).ToString("N2");
ApplicationFunction.DatatableAddRow(DtTemp, Id, hidTocity_Idno.Value, lblCityName.Text, txtCommissionAmnt.Text);
Id++;
}
}
grdMain.SetPageIndex(a);
ViewState["dt"] = DtTemp;
grdMain.DataSource = DtTemp;
grdMain.DataBind();
}
else
{
ShowMessageErr("Please enter details for Save Data");
ddlState.Focus(); txtCommsision.Text = "0.00";
return;
}
}
else
{
ShowMessage("Please enter Amount Greater Than Zero");
txtCommsision.Focus();
}
}
public void Populate(Int32 intMatIdNo)
{
TyreIssueDAL obj = new TyreIssueDAL();
TyreIssHead objMatHead = obj.SelectMatHead(intMatIdNo);
var objMatDetl = obj.SelectMatDetail(intMatIdNo);
hidGRHeadIdno.Value = Convert.ToString(intMatIdNo);
if (objMatHead != null)
{
ddlDateRange.SelectedValue = Convert.ToString(objMatHead.Year_Idno);
txtGRDate.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_Date)) ? "" : Convert.ToDateTime(objMatHead.MatIss_Date).ToString("dd-MM-yyyy");
iGrAgainst = Convert.ToInt32(objMatHead.MatIss_Typ);
// RDbDirect.Enabled = false; RDbRecpt.Enabled = false;
//new
txtRemarkhead.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.ReMark)) ? "" : Convert.ToString(objMatHead.ReMark);
txtGRNo.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_No)) ? "" : Convert.ToString(objMatHead.MatIss_No);
ddlTruckNo.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Truck_Idno)) ? "0" : Convert.ToString(objMatHead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
ddlDriver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno);
ddlReciver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno);
ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Loc_Idno)) ? "0" : Convert.ToString(objMatHead.Loc_Idno);
dtTemp = CreateDt();
for (int counter = 0; counter < objMatDetl.Count; counter++)
{
string strItemName = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Name"));
string strItemNameId = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Iteam_Idno"));
string strQty = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Qty"));
string strWeight = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Weght"));
string strRate = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Rate"));
string strAmount = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Amnt"));
string strDetail = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Remark"));
string strStckdetlNO = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerialNo"));
string strStckdetl_Idno = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerlDetl_id"));
ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail, strStckdetlNO, strStckdetl_Idno);
}
ViewState["dt"] = dtTemp;
BindGridT();
txtNetAmnt.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.Net_Amnt)) ? "0" : String.Format("{0:0,0.00}", objMatHead.Net_Amnt);
PrintMaterial(objMatHead, objMatDetl);
}
obj = null;
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
dtTemp = (DataTable)ViewState["dt"];
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
dtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = dtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
ddlDateRange.SelectedValue = Convert.ToString(drs[0]["YearIdno"]);
ddlLocation.SelectedValue = Convert.ToString(drs[0]["LocIdno"]);
ddlItemName.SelectedValue = Convert.ToString(drs[0]["ItemIdno"]);
txtQty.Text = string.IsNullOrEmpty(Convert.ToString(drs[0]["Qty"])) == true ? "0" : Convert.ToString(drs[0]["Qty"]);
txtOpenRate.Text = string.IsNullOrEmpty(Convert.ToString(drs[0]["Rate"])) == true ? "0.00" : Convert.ToDouble(drs[0]["Rate"]).ToString("N2");
ViewState["ID"] = Convert.ToString(drs[0]["id"]);
}
}
else if (e.CommandName == "cmddelete")
{
DataTable dtInnerDelete = CreateDt();
DataTable objDataTable = CreateDt();
foreach (DataRow rw in dtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["YearIdno"], rw["LocIdno"], rw["LocName"], rw["ItemIdno"], rw["ItemName"], rw["Qty"], rw["Rate"]);
}
else
{
ApplicationFunction.DatatableAddRow(dtInnerDelete, rw["id"], rw["YearIdno"], rw["LocIdno"], rw["LocName"], rw["ItemIdno"], rw["ItemName"], rw["Qty"], rw["Rate"]);
}
}
ViewState["dt"] = objDataTable;
ViewState["dtDelete"] = dtInnerDelete;
this.AccDelete();
objDataTable.Dispose();
this.BindGridT();
}
}
private void BindGridDB()
{
OpenAccDAL objOpeningStock = new OpenAccDAL();
DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString());
if (dtItem.Rows.Count > 0)
{
for (int i = 0; i < dtItem.Rows.Count; i++)
{
dtTemp = (DataTable)ViewState["dt"];
if ((dtTemp != null) && (dtTemp.Rows.Count > 0))
{
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToString(row["ItemIdno"]) == dtItem.Rows[i]["Item_Idno"].ToString() && Convert.ToString(row["LocIdno"]) == Convert.ToString(ddlLocation.SelectedValue))
{
string msg = "Item Already Exist For Same Location";
ddlItemName.Focus();
ShowMessageErr(msg);
return;
}
}
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string strYearIdno = string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : (ddlDateRange.SelectedValue);
string strItemName = dtItem.Rows[i]["Item_Name"].ToString();
string strItemIdno = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Idno"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Idno"].ToString());
string strLocName = ddlLocation.SelectedItem.Text.Trim();
string strLocIdno = string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : (ddlLocation.SelectedValue);
string strQty = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Qty"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Qty"].ToString());
string strRate = string.IsNullOrEmpty(dtItem.Rows[i]["Item_Rate"].ToString()) ? "0" : (dtItem.Rows[i]["Item_Rate"].ToString());
ApplicationFunction.DatatableAddRow(dtTemp, id, strYearIdno, strLocIdno, strLocName, strItemIdno, strItemName, strQty, strRate);
}
}
ViewState["dt"] = dtTemp;
this.BindGridT();
txtQty.Text = "";
txtOpenRate.Text = "";
ddlItemName.SelectedValue = "0";
ddlLocation.SelectedValue = "0";
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
dtTemp = (DataTable)ViewState["dt"];
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
dtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = dtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
DdlFromCty.SelectedItem.Text = Convert.ToString(drs[0]["FromCity"]);
DdlToCty.SelectedItem.Text = Convert.ToString(drs[0]["ToCity"]);
txtLeg.Text = Convert.ToString(drs[0]["Leg"]);
txtETA.Text = Convert.ToString(drs[0]["ETA"]);
txtATA.Text = Convert.ToString(drs[0]["ATA"]);
txtETD.Text = Convert.ToString(drs[0]["ETD"]);
txtATD.Text = Convert.ToString(drs[0]["ATD"]);
txtTAThrs.Text = Convert.ToString(drs[0]["TAT_in_hrs"]);
Txtdelayhrs.Text = Convert.ToString(drs[0]["Delay_in_hrs"]);
txtremark.Text = Convert.ToString(drs[0]["Remarks"]);
Hidrowid.Value = Convert.ToString(drs[0]["id"]);
DdlFromCty.SelectedValue = Convert.ToString(drs[0]["FromCityIdno"]);
DdlToCty.SelectedValue = Convert.ToString(drs[0]["ToCityIdno"]);
}
}
else if (e.CommandName == "cmddelete")
{
DataTable objDataTable = CreateDt();
foreach (DataRow rw in dtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["FromCity"], rw["ToCity"], rw["Leg"], rw["ETA"], rw["ATA"], rw["ETD"], rw["ATD"], rw["TAT_in_hrs"], rw["Delay_in_hrs"], rw["Remarks"], rw["FromCityIdno"], rw["ToCityIdno"]);
}
}
ViewState["dt"] = objDataTable;
objDataTable.Dispose();
this.BindGridT();
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
dtTemp = (DataTable)ViewState["dt"];
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
dtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = dtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
txtGrNo.Text = Convert.ToString(drs[0]["GR_No"]);
txtGRDate.Text = Convert.ToDateTime(drs[0]["GR_Date"]).ToString("dd-MM-yyyy");
ddlGrType.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["Gr_TypeIdno"]) == "" ? 0 : drs[0]["Gr_TypeIdno"]);
ddlfromCity.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["FromCityIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["FromCityIdno"]));
ddltoCity.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["ToCityIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["ToCityIdno"]));
ddlSenderName.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["SenderNameIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["SenderNameIdno"]));
ddlReciverName.SelectedValue = Convert.ToString(Convert.ToString(drs[0]["ReciverNameIdno"]) == "" ? 1 : Convert.ToInt64(drs[0]["ReciverNameIdno"]));
txtQuantity.Text = Convert.ToString(drs[0]["Qty"]);
txtweight.Text = Convert.ToString(drs[0]["Weight"]);
txtAmount.Text = String.Format("{0:0,0.00}", Convert.ToDouble(drs[0]["Amount"]));
txtdetail.Text = Convert.ToString(drs[0]["Detail"]);
Hidrowid.Value = Convert.ToString(drs[0]["id"]);
}
}
else if (e.CommandName == "cmddelete")
{
DataTable objDataTable = CreateDt();
foreach (DataRow rw in dtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(objDataTable, rw["id"], rw["GR_No"], rw["Gr_Date"], rw["Gr_Type"], rw["Gr_TypeIdno"], rw["FromCity"], rw["FromCityIdno"], rw["ToCity"], rw["ToCityIdno"], rw["SenderName"], rw["SenderNameIdno"],
rw["ReciverName"], rw["ReciverNameIdno"], rw["Qty"], rw["Weight"], rw["Amount"], rw["Detail"]);
}
}
ViewState["dt"] = objDataTable;
objDataTable.Dispose();
this.BindGridT();
}
}
private void BindGridDB()
{
OpenTyreDAL objOpeningStock = new OpenTyreDAL();
DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString());
if (dtItem.Rows.Count > 0)
{
for (int i = 0; i < dtItem.Rows.Count; i++)
{
dtTemp = (DataTable)ViewState["dt"];
if ((dtTemp != null) && (dtTemp.Rows.Count > 0))
{
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToString(row["SerialNo"]) == Convert.ToString(dtItem.Rows[i]["SerialNo"].ToString()))
{
string msg = "Serial No. Already Exist For Same Item";
ddlItemName.Focus();
ShowMessageErr(msg);
return;
}
}
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string compName = dtItem.Rows[i]["CompanyName"].ToString();
string strSerialNo = dtItem.Rows[i]["SerialNo"].ToString();
string TypeID = dtItem.Rows[i]["Type_Idno"].ToString();
string strType = dtItem.Rows[i]["Type"].ToString();
string strPur = dtItem.Rows[i]["PurchaseFrom"].ToString();
string strItemName = dtItem.Rows[i]["Item_Name"].ToString();
string strItemIdno = dtItem.Rows[i]["Item_Idno"].ToString();
string openRate = Convert.ToDouble(dtItem.Rows[i]["Item_Rate"].ToString()).ToString("N2");
ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, strItemName, strItemIdno);
}
}
ViewState["dt"] = dtTemp;
this.BindGridT();
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "GetExcel")
{
DataTable DtCsv = CreateDt();
Int32 RowId = Convert.ToInt32(e.CommandArgument);
GridViewRow CurRow = (GridViewRow)grdMain.Rows[RowId];
HiddenField hidLocId = (HiddenField)CurRow.FindControl("hidLocId");
HiddenField hidYearId = (HiddenField)CurRow.FindControl("hidYearId");
OpenTyreDAL objItemMastDAL = new OpenTyreDAL();
var lst = objItemMastDAL.GetExcel(Convert.ToInt64(hidLocId.Value), Convert.ToInt64(hidYearId.Value));
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
ApplicationFunction.DatatableAddRow(DtCsv, Convert.ToString(DataBinder.Eval(lst[i], "SerialNo")), Convert.ToString(DataBinder.Eval(lst[i], "CompanyName")), Convert.ToString(DataBinder.Eval(lst[i], "LoctionName")), Convert.ToString(DataBinder.Eval(lst[i], "ItemName")),
"", Convert.ToString(DataBinder.Eval(lst[i], "Rate")), "");
}
if ((DtCsv != null) && (DtCsv.Rows.Count != 0))
{
DtCsv.Columns["LoctionName"].Caption = "Location";
DtCsv.Columns["ItemName"].ColumnName = "TyreName";
DtCsv.Columns["Rate"].Caption = "Rate";
DtCsv.Columns["SerialNo"].SetOrdinal(0);
DtCsv.Columns["CompanyName"].SetOrdinal(1);
DtCsv.Columns["LoctionName"].SetOrdinal(2);
DtCsv.Columns["TyreName"].SetOrdinal(3);
DtCsv.Columns["Rate"].SetOrdinal(4);
DtCsv.Columns.Remove("Qty");
DtCsv.Columns.Remove("Amount");
DtCsv.AcceptChanges();
ExportDataTableToCSV(DtCsv, Convert.ToString("OpeningItemDetails"));
Response.Redirect("ManageOpenStock.aspx");
}
}
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = Convert.ToInt32(e.CommandArgument);
DtTemp = (DataTable)ViewState["dt"];
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
DtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = DtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
Hidrowid.Value = Convert.ToString(drs[0]["Id"]);
txtSummaryNo.Text = Convert.ToString(drs[0]["Sumry_No"]);
txtRecDate.Text = Convert.ToDateTime((drs[0]["Recvng_Date"])).ToString("dd-MM-yyyy");
txtReceivedAmount.Text = Convert.ToString(drs[0]["Recvng_Amnt"]);
txtRemark.Text = Convert.ToString(drs[0]["Remark"]);
Hidrowid.Value = Convert.ToString(drs[0]["id"]);
}
drpChallanDetail.Focus();
}
else if (e.CommandName == "cmddelete")
{
DataTable dt = CreateDt();
foreach (DataRow rw in DtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(dt, rw["id"], rw["Sumry_No"], rw["Recvng_Date"],
rw["Recvng_Amnt"], rw["Remark"]);
}
}
ViewState["dt"] = dt;
dt.Dispose();
this.BindGrid();
}
}
protected void lnkBtnSave_Click(object sender, EventArgs e)
{
UpdateGrDetailDAL obj = new UpdateGrDetailDAL();
int count = 0; Int64 GrDetail = 0;
Int64 qty = 0, GrNumber = 0; double Weight = 0;
if (grdMain.Rows.Count <= 0)
{
ShowMessageErr("Please Enter Grid Details");
}
else
{
CreateDt();
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGridno");
HiddenField hidItemidno = (HiddenField)row.FindControl("hidItemidno");
HiddenField hidUnitidno = (HiddenField)row.FindControl("hidUnitidno");
HiddenField hidGrdetlidno = (HiddenField)row.FindControl("hidGrdetlidno");
Label lblrateType = (Label)row.FindControl("lblrateType");
TextBox txtQty = (TextBox)row.FindControl("txtQty");
qty = Convert.ToInt64(txtQty.Text);
TextBox txtWeight = (TextBox)row.FindControl("txtWeight");
Weight = Convert.ToDouble(txtWeight.Text);
Label GRno = (Label)row.FindControl("lblGrNo");
GrNumber = Convert.ToInt64(GRno.Text);
ApplicationFunction.DatatableAddRow(DtTemp, hidGrdetlidno.Value, hidGrIdno.Value, hidItemidno.Value, hidUnitidno.Value, ((lblrateType.Text) == "Rate") ? "1" : "2", qty, Weight);
}
if (qty > 0 && Weight > 0)
{
bool value = obj.UpdateGrDetl(DtTemp, Convert.ToInt64(ddlLocation.SelectedValue));
ShowMessage("Update Successfully");
}
else
{
ShowMessageErr("Quanity and Weight Must Be Greater then Zero");
}
}
}
protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
if (RDbSaleBill.Checked == true)
{
if (txtSBillNo.Text == "" && ddlDivPrtyName.SelectedValue == "0")
{
DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Sale Bill Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return;
}
else
{
grdSearchRecords.Visible = true;
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string SbillNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim()));
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, SbillNo, PartyIdno, Location, intyearid);
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "SBillDate")).ToString("dd-MM-yyyy"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
else
{
grdSearchRecords.Visible = true;
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
var lst = objClaimFrmDAL.SearchByParty(PartyIdno, Location, intyearid);
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = ""; string BillNo = "0"; string SbillIdNo = "0"; string SBillDate = "";
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
objClaimFrmDAL = null;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DateTime?ClaimDate = null;
ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
objClaimFrmDAL = new ClaimToDAL();
DateTime CurrentDate = System.DateTime.Now;
if (grdMain.Rows.Count > 0)
{
DTMain = CreateDt();
if (rdoAgnReceived.Checked)
{
foreach (GridViewRow row in grdMain.Rows)
{
Label lblGridSerialNo = (Label)row.FindControl("lblGridSerialNo");
TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo");
DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
if (txtNewSerialNo.Text.Trim() == "")
{
ShowMessageErr("Please Fill Serial Number."); txtNewSerialNo.Focus(); return;
}
if (lblGridSerialNo.Text.Trim() == txtNewSerialNo.Text.Trim())
{
ShowMessageErr("New Serial Not same as old Serial,Check New Serial No." + txtNewSerialNo.Text.Trim() + ""); txtNewSerialNo.Focus(); return;
}
if (ddlStatus.SelectedValue == "1")
{
ShowMessageErr("Please Check Status should not be submitted."); ddlStatus.Focus(); return;
}
BindDropdownDAL obj = new BindDropdownDAL();
if (Request.QueryString["ClaimHeadIdno"] == null)
{
if (txtNewSerialNo.Text.Trim() != "")
{
Int64 Count = obj.CheckSerialNo(txtNewSerialNo.Text.Trim());
if (Count != 0)
{
ShowMessageErr("Serial Number :" + txtNewSerialNo.Text.Trim() + " already exists in stock.");
txtNewSerialNo.Focus();
return;
}
}
}
}
}
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno");
HiddenField hidClaimIdno = (HiddenField)row.FindControl("hidClaimIdno");
Label txtDefRemark = (Label)row.FindControl("lblGridDefectNo");
Label txtVchAppDetl = (Label)row.FindControl("lblGridVehDetlNo");
DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
TextBox txtRemarks = (TextBox)row.FindControl("txtRemarks");
TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo");
HiddenField HidClaimDetailsIdno = (HiddenField)row.FindControl("HidClaimDetailsIdno");
ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidClaimIdno.Value, txtDefRemark.Text.Trim(), txtVchAppDetl.Text.Trim(), ddlStatus.SelectedValue, txtRemarks.Text.Trim(), txtNewSerialNo.Text.Trim(), HidClaimDetailsIdno.Value);
}
if (rdoAgnReceived.Checked)
{
foreach (GridViewRow rows in grdMain.Rows)
{
TextBox txtNewSerialNo1 = (TextBox)rows.FindControl("txtNewSerialNo");
DataRow[] drs = DTMain.Select("NewSerialNo='" + txtNewSerialNo1.Text.Trim() + "'");
if (drs.Length > 1)
{
ShowMessageErr("Serial Number :" + txtNewSerialNo1.Text.Trim() + " already exists in list.");
txtNewSerialNo1.Focus();
return;
}
}
}
tblClaimToComHead objClaimHead = new tblClaimToComHead();
if (rdoAgnReceived.Checked)
{
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimToComRec_Date = null;
}
else
{
objClaimHead.ClaimToComRec_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
}
else
{
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimToComHead_Date = null;
}
else
{
objClaimHead.ClaimToComHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
}
objClaimHead.ClaimToCom_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim());
objClaimHead.ClaimHead_Idno = string.IsNullOrEmpty(Convert.ToString(HidClaimHeadIdno.Value)) ? 0 : Convert.ToInt64(HidClaimHeadIdno.Value);
objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim());
objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue);
objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue);
objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue);
Int64 Against = 0; if (rdoAgnSend.Checked)
{
Against = 1;
}
else
{
Against = 2;
}
objClaimHead.Against = Against;
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
objClaimHead.Date_Added = System.DateTime.Now;
value = objClaimFrmDAL.Insert(objClaimHead, DTMain);
objClaimFrmDAL = null;
}
else
{
objClaimHead.Date_Modified = System.DateTime.Now;
lnkbtnNew.Visible = false;
if (rdoAgnReceived.Checked)
{
value = objClaimFrmDAL.UpdateForRecvd(objClaimHead, Convert.ToInt32(hidid.Value), DTMain);
}
else
{
value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(hidid.Value), DTMain);
}
objClaimFrmDAL = null;
}
if (string.IsNullOrEmpty(hidid.Value) == false)
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not Update");
tScope.Dispose();
}
}
else
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record saved Successfully ");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not saved Successfully ");
tScope.Dispose();
}
}
}
}
else
{
ShowMessageErr("Please Search and Select Serial Number.");
return;
}
}
protected void lnkbtnSearch_Click(object sender, EventArgs e)
{
grdSearchRecords.Visible = true;
objClaimFrmDAL = new ClaimToDAL();
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()));
Int64 Value = 1;
if (rdoAgnReceived.Checked)
{
Value = 2;
}
else
{
Value = 1;
}
if (Value == 2)
{
var lst = objClaimFrmDAL.SelectForSearchRecvd(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
hidid.Value = SbillIdNo;
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
else
{
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string ClaimHeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string CBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, ClaimHeadIdno, PrefNo + "" + ClaimNumber, ApplicationFunction.mmddyyyy(CBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
HidClaimHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "ClaimHeadIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "ClaimHeadIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (ddlItemName.SelectedIndex == 0)
{
ShowMessageErr("Please select Item."); ddlItemName.Focus(); return;
}
{ if (txtweight.Text == "" || Convert.ToDouble(txtweight.Text) <= 0)
{
ShowMessageErr("Weight should be greater than zero."); txtweight.Focus(); return;
}
}
// if (txtQuantity.Text == "" || Convert.ToDouble(txtQuantity.Text) <= 0) { ShowMessageErr("Quantity should be greater than zero."); txtQuantity.Focus(); return; }
if (txtrate.Text == "" || Convert.ToDouble(txtrate.Text) <= 0)
{
ShowMessageErr("Rate should be greater than zero.");
txtrate.Focus();
return;
}
else if (txtrate.Text == "" || Convert.ToDouble(txtrate.Text) <= 0)
{
ShowMessageErr("Rate should be greater than zero.");
txtrate.Focus();
return;
}
//else
//{
// txtrate.Text = "0.00";
//}
CalculateEdit();
string strAmount = "";
if (hidrowid.Value != string.Empty)
{
dtTemp = (DataTable)ViewState["dt"];
foreach (DataRow dtrow in dtTemp.Rows)
{
if (Convert.ToString(dtrow["id"]) == Convert.ToString(hidrowid.Value))
{
dtrow["Item_Name"] = ddlItemName.SelectedItem.Text;
dtrow["Item_Idno"] = ddlItemName.SelectedValue;
dtrow["Quantity"] = Convert.ToString(1); iqty += Convert.ToDouble(1);
dtrow["Weight"] = txtweight.Text.Trim();
dtrow["Rate"] = txtrate.Text.Trim();
dtrow["Amount"] = dtotalAmount.ToString("N2");
dtrow["Serial_No"] = ddlSerialNo.SelectedItem.Text;
dtrow["Serial_Idno"] = ddlSerialNo.SelectedValue;
//kapil
//dtrow["Detail"] = string.Empty;
//dtrow["Detail"] = txtremark.Text.Trim();
}
}
}
else
{
dtTemp = (DataTable)ViewState["dt"];
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string strItemName = ddlItemName.SelectedItem.Text.Trim();
string strItemNameId = string.IsNullOrEmpty(ddlItemName.SelectedValue) ? "0" : (ddlItemName.SelectedValue);
//string strQty = string.IsNullOrEmpty(txtQuantity.Text.Trim()) ? "0" : (txtQuantity.Text.Trim());
string strQty = Convert.ToString(1);
string strWeight = string.IsNullOrEmpty(txtweight.Text.Trim()) ? "0" : (txtweight.Text.Trim());
string strRate = string.IsNullOrEmpty(txtrate.Text.Trim()) ? "0.00" : (txtrate.Text.Trim());
string strSerialNo = string.IsNullOrEmpty(ddlSerialNo.SelectedItem.Text) ? "0" : (ddlSerialNo.SelectedItem.Text);
string strSerialIdno = string.IsNullOrEmpty(ddlSerialNo.SelectedValue) ? "0" : (ddlSerialNo.SelectedValue);
strAmount = dtotalAmount.ToString("N2");
//kapil
//string strDetail = string.IsNullOrEmpty(txtremark.Text.Trim()) ? "" : (txtremark.Text.Trim());\
ApplicationFunction.DatatableAddRow(dtTemp, id, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, string.Empty, strSerialNo, strSerialIdno);
//ApplicationFunction.DatatableAddRow(dtTemp, id, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail);
ViewState["dt"] = dtTemp;
}
this.BindGridT();
ddlItemName.Focus();
ClearItems();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "filltxtthrough()", true);
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (ViewState["ID"] == null)
{
if (ddlItemName.SelectedIndex == 0)
{
ShowMessageErr("Please select Tyre."); ddlItemName.Focus(); return;
}
}
if (ddlLocation.SelectedIndex == 0)
{
ShowMessageErr("Please select Location."); ddlLocation.Focus(); return;
}
if (ddltyresize.SelectedIndex == 0)
{
ShowMessageErr("Please select Tyre Size."); ddltyresize.Focus(); return;
}
if (txtSerialNo.Text == "")
{
ShowMessageErr("Enter Serial No."); txtSerialNo.Focus(); return;
}
if (IsExist(txtSerialNo.Text.Trim()) == true)
{
ShowMessageErr("Serial No:" + txtSerialNo.Text.Trim() + " already in stock"); txtSerialNo.Focus(); return;
}
string TotalAmount = string.Empty;
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
ddlItemName.Enabled = false;
}
else
{
ddlItemName.Enabled = false;
}
if (ViewState["ID"] != null)
{
foreach (DataRow dtrow in dtTemp.Rows)
{
if (Convert.ToString(dtrow["id"]) == Convert.ToString(ViewState["ID"].ToString()))
{
dtrow["SerialNo"] = txtSerialNo.Text.Trim();
dtrow["CompName"] = txtCompName.Text.Trim();
dtrow["TypeId"] = ddltype.SelectedValue;
dtrow["Type"] = ddltype.SelectedItem.Text;
dtrow["TyreSizeIdno"] = ddltyresize.SelectedValue;
dtrow["TyreSize"] = ddltyresize.SelectedItem.Text;
dtrow["PurFrom"] = txtPurchaseFrom.Text.Trim();
dtrow["OpenRate"] = Convert.ToDouble(txtOpenRate.Text.Trim()).ToString("N2");
lnkbtnSubmit.Focus();
}
}
ViewState["ID"] = null;
}
else
{
dtTemp = (DataTable)ViewState["dt"];
if ((dtTemp != null) && (dtTemp.Rows.Count > 0))
{
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToString(row["SerialNo"]) == Convert.ToString(txtSerialNo.Text.Trim()))
{
string msg = "Serial No Already Entered!";
ddlItemName.Focus();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + msg + "')", true);
return;
}
}
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string compName = string.IsNullOrEmpty(txtCompName.Text.Trim()) ? "" : txtCompName.Text.Trim();
string strSerialNo = txtSerialNo.Text.Trim();
string TypeID = string.IsNullOrEmpty(ddltype.SelectedValue) ? "0" : (ddltype.SelectedValue);
string strType = ddltype.SelectedItem.Text.Trim();
string strPur = txtPurchaseFrom.Text.Trim();
string openRate = Convert.ToDouble(txtOpenRate.Text.Trim()).ToString("N2");
string ItemName = ddlItemName.SelectedItem.Text;
string ItemItem = ddlItemName.SelectedValue;
string tyresize = ddltyresize.SelectedItem.Text;
string tyresizeidno = ddltyresize.SelectedValue;
ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, ItemName, ItemItem, "", tyresize, tyresizeidno);
}
ViewState["dt"] = dtTemp;
this.BindGridT();
txtSerialNo.Text = "";
txtCompName.Text = "";
txtPurchaseFrom.Text = "";
txtOpenRate.Text = "";
ddlItemName.Enabled = true; rfvPartno.Enabled = true;
lnkbtnNew.Visible = true;
txtSerialNo.Focus();
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (DdlVehicleNo.SelectedValue == "0")
{
ShowMessage("Please Select Vehicle No.");
DdlVehicleNo.Focus();
return;
}
if (DdlLane.SelectedValue == "0")
{
ShowMessage("Please Select Lane.");
DdlLane.Focus();
return;
}
if (DdlFromCity.SelectedValue == "0")
{
ShowMessage("Please Enter from City.");
DdlFromCity.Focus();
return;
}
if (DdlToCity.SelectedValue == "0")
{
ShowMessage("Please Enter To City.");
DdlToCity.Focus();
return;
}
if (DdlFromLoc.SelectedValue == "0")
{
ShowMessage("Please Enter From Location.");
DdlFromLoc.Focus();
return;
}
if (DdlCompName.SelectedValue == "0")
{
ShowMessage("Please Enter Company Name.");
DdlCompName.Focus();
return;
}
if (DdlFromCty.SelectedValue == "0")
{
ShowMessage("Please Enter from City.");
DdlFromCty.Focus();
return;
}
if (DdlToCty.SelectedValue == "0")
{
ShowMessage("Please Enter To City.");
DdlToCty.Focus();
return;
}
if (txtLeg.Text == "")
{
ShowMessage("Leg should be greater than zero.");
txtLeg.Focus();
return;
}
if (txtETA.Text == "" || txtETA.Text == "0:00")
{
ShowMessage("ETA should be greater than zero.");
txtETA.Focus();
return;
}
if (txtATA.Text == "" || txtATA.Text == "0:00")
{
ShowMessage("ATA should be greater than zero.");
txtATA.Focus();
return;
}
if (txtETD.Text == "" || txtETD.Text == "0:00")
{
ShowMessage("ETD should be greater than zero.");
txtETD.Focus();
return;
}
if (txtATD.Text == "" || txtATD.Text == "0:00")
{
ShowMessage("ATD should be greater than zero.");
txtATD.Focus();
return;
}
if (txtTAThrs.Text == "" || txtTAThrs.Text == "0:00")
{
ShowMessage("TAT In Hrs should be greater than zero.");
txtTAThrs.Focus();
return;
}
if (Txtdelayhrs.Text == "" || Txtdelayhrs.Text == "0:00")
{
ShowMessage("Delay In Hrs should be greater than zero.");
Txtdelayhrs.Focus();
return;
}
if (Hidrowid.Value != string.Empty)
{
dtTemp = (DataTable)ViewState["dt"];
foreach (DataRow dtrow in dtTemp.Rows)
{
if (Convert.ToString(dtrow["Id"]) == Convert.ToString(Hidrowid.Value))
{
dtrow["FromCity"] = DdlFromCty.SelectedItem.Text;
dtrow["ToCity"] = DdlToCty.SelectedItem.Text;
dtrow["Leg"] = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim());
dtrow["ETA"] = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim());
dtrow["ATA"] = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim());
dtrow["ETD"] = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim());
dtrow["ATD"] = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim());
dtrow["TAT_in_hrs"] = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim());
dtrow["Delay_in_hrs"] = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim());
dtrow["Remarks"] = txtremark.Text;
dtrow["FromCityIdno"] = string.IsNullOrEmpty(DdlFromCty.SelectedValue.ToString()) ? "0" : (DdlFromCty.SelectedValue.ToString());
dtrow["ToCityIdno"] = string.IsNullOrEmpty(DdlToCty.SelectedValue.ToString()) ? "0" : (DdlToCty.SelectedValue.ToString());
}
}
}
else
{
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp == null)
{
dtTemp = CreateDt();
ViewState["dt"] = dtTemp;
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["Id"])) + 1;
string strFromCity = DdlFromCty.SelectedItem.Text;
string strToCity = DdlToCty.SelectedItem.Text;
string strLeg = string.IsNullOrEmpty(txtLeg.Text.Trim()) ? "0" : (txtLeg.Text.Trim());
string strETA = string.IsNullOrEmpty(txtETA.Text.Trim()) ? "0" : (txtETA.Text.Trim());
string strATA = string.IsNullOrEmpty(txtATA.Text.Trim()) ? "0" : (txtATA.Text.Trim());
string strETD = string.IsNullOrEmpty(txtETD.Text.Trim()) ? "0" : (txtETD.Text.Trim());
string strATD = string.IsNullOrEmpty(txtATD.Text.Trim()) ? "0" : (txtATD.Text.Trim());
string strTAThrs = string.IsNullOrEmpty(txtTAThrs.Text.Trim()) ? "0" : (txtTAThrs.Text.Trim());
string strdelayhrs = string.IsNullOrEmpty(Txtdelayhrs.Text.Trim()) ? "0" : (Txtdelayhrs.Text.Trim());
string strReamrks = txtremark.Text.Trim();
string strFromCityIdno = DdlFromCty.SelectedValue;
string strToCityIdno = DdlToCty.SelectedValue;
ApplicationFunction.DatatableAddRow(dtTemp, id, strFromCity, strToCity, strLeg, strETA, strATA, strETD, strATD, strTAThrs, strdelayhrs, strReamrks, strFromCityIdno, strToCityIdno);
ViewState["dt"] = dtTemp;
}
this.BindGridT();
ClearItems();
BindCityDropDown();
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
string msg = string.Empty;
if (drpItemType.SelectedIndex == 0)
{
this.ShowMessage("Please select Item Type");
drpItemType.Focus();
return;
}
if (drpItemType.SelectedIndex == 1)
{
if (ddlTyreType.SelectedIndex == 0)
{
this.ShowMessage("Please Select Tyre Type");
ddlTyreType.Focus();
return;
}
if (drpSerialNo.SelectedIndex == 0)
{
this.ShowMessage("Please Select Serial No or Part No.");
drpSerialNo.Focus();
return;
}
if (txtQty.Text == string.Empty || Convert.ToDouble(txtQty.Text) <= 0)
{
this.ShowMessage("Qty must be greater than 0.");
txtQty.Focus();
return;
}
if (txtRate.Text == string.Empty || Convert.ToDouble(txtRate.Text) <= 0)
{
this.ShowMessage("Rate must be greater than 0.");
txtRate.Focus();
return;
}
rfvSerialNo.Enabled = true;
}
else
{
if (txtQty.Text == string.Empty || Convert.ToDouble(txtQty.Text) <= 0)
{
this.ShowMessage("Qty must be greater than 0.");
txtQty.Focus();
return;
}
if (txtRate.Text == string.Empty || Convert.ToDouble(txtRate.Text) <= 0)
{
this.ShowMessage("Rate must be greater than 0.");
txtRate.Focus();
return;
}
rfvSerialNo.Enabled = false;
}
if (hidrowid.Value != string.Empty)
{
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp != null && DtTemp.Rows.Count > 0)
{
foreach (DataRow dtrow in DtTemp.Rows)
{
if (Convert.ToString(dtrow["id"]) == Convert.ToString(hidrowid.Value))
{
dtrow["ITEM_TYPE"] = drpItemType.SelectedItem.Text;
dtrow["ITEM_TYPEID"] = drpItemType.SelectedValue;
if (Convert.ToInt32(dtrow["ITEM_TYPEID"]) == 1)
{
dtrow["ITEM_SERIAL"] = string.IsNullOrEmpty(drpSerialNo.SelectedItem.Text) ? "" : Convert.ToString(drpSerialNo.SelectedItem.Text);
dtrow["TYRE_TYPE"] = ddlTyreType.SelectedItem.Text;
}
else
{
dtrow["ITEM_SERIAL"] = "";
dtrow["TYRE_TYPE"] = "";
}
dtrow["ITEM_SERIALID"] = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? 0 : Convert.ToInt32(drpSerialNo.SelectedValue);
dtrow["TYRE_TYPEID"] = ddlTyreType.SelectedValue;
dtrow["ITEM_QTY"] = txtQty.Text;
dtrow["ITEM_RATE"] = txtRate.Text;
dtrow["ITEM_AMOUNT"] = Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text));
dtrow["ITEM_NAME"] = drpItemName.SelectedItem.Text;
dtrow["ITEM_ID"] = drpItemName.SelectedValue;
// dtrow["UOM_ID"] = hiduomid.Value;
}
}
}
}
else
{
DtTemp = (DataTable)ViewState["dt"];
if ((DtTemp != null) && (DtTemp.Rows.Count > 0))
{
foreach (DataRow row in DtTemp.Rows)
{
if (Convert.ToInt32(row["ITEM_TYPEID"]) == 1)
{
if (Convert.ToInt32(row["ITEM_SERIALID"]) == Convert.ToInt32(string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? 0 : Convert.ToInt32(drpSerialNo.SelectedValue)) && (Convert.ToInt32(row["ITEM_TYPEID"]) == Convert.ToInt32(drpItemType.SelectedValue)))
{
msg = "Item Already Selected!";
drpSerialNo.Focus(); drpSerialNo.SelectedIndex = 0;
this.ShowMessage(msg);
return;
}
}
else
{
if (Convert.ToInt32(row["ITEM_ID"]) == Convert.ToInt32(string.IsNullOrEmpty(drpItemName.SelectedValue) ? 0 : Convert.ToInt32(drpItemName.SelectedValue)) && (Convert.ToInt32(row["ITEM_TYPEID"]) == Convert.ToInt32(drpItemType.SelectedValue)))
{
msg = "Item Already Selected!";
drpItemName.Focus(); drpItemName.SelectedIndex = 0;
this.ShowMessage(msg);
return;
}
}
}
}
else
{
DtTemp = CreateDt();
}
int id = DtTemp.Rows.Count == 0 ? 1 : DtTemp.Rows.Count + 1;
if (drpItemType.SelectedValue == "1")
{
ApplicationFunction.DatatableAddRow(DtTemp, id, drpItemType.SelectedItem.Text, drpItemType.SelectedValue, drpSerialNo.SelectedItem.Text,
drpSerialNo.SelectedValue, ddlTyreType.SelectedItem.Text, ddlTyreType.SelectedValue, txtQty.Text, txtRate.Text, Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text)), drpItemName.SelectedItem.Text, drpItemName.SelectedValue);
}
else
{
ApplicationFunction.DatatableAddRow(DtTemp, id, drpItemType.SelectedItem.Text, drpItemType.SelectedValue, "",
"", "", "", txtQty.Text, txtRate.Text, Convert.ToString(Convert.ToDouble(txtQty.Text) * Convert.ToDouble(txtRate.Text)), string.IsNullOrEmpty(drpItemName.SelectedValue) ? "" : Convert.ToString(drpItemName.SelectedItem.Text), string.IsNullOrEmpty(drpItemName.SelectedValue) ? "" : Convert.ToString(drpItemName.SelectedValue));
}
ViewState["dt"] = DtTemp;
}
this.BindGrid();
this.ClearItems();
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
StockTransferDAL objStck = new StockTransferDAL();
int id = Convert.ToInt32(e.CommandArgument);
DtTemp = (DataTable)ViewState["dt"];
//GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent;
if (e.CommandName == "cmdedit")
{
DtTemp = (DataTable)ViewState["dt"];
DataRow[] drs = DtTemp.Select("Id='" + id + "'");
if (drs.Length > 0)
{
drpItemType.SelectedValue = Convert.ToString(drs[0]["ITEM_TYPEID"]);
if (Convert.ToInt32(hidStckid.Value) > 0)
{
BindItemName();
if ((drpItemType.SelectedValue == "1"))
{
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
BindItem();
ddlTyreType.SelectedValue = string.IsNullOrEmpty(ddlTyreType.SelectedValue) ? "0" : Convert.ToString(drs[0]["TYRE_TYPEID"]);
ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true;
txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true;
}
else
{
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1";
drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false;
}
}
else
{
if (drpItemType.SelectedValue == "1")
{
BindItemName();
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
BindItem();
drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]);
ddlTyreType.SelectedValue = Convert.ToString(drs[0]["TYRE_TYPEID"]);
ddlTyreType.Enabled = true; txtQty.Text = "1"; ddlTyreType.Enabled = true;
txtQty.Enabled = false; rfvddlTyreType.Enabled = true; drpSerialNo.Enabled = true; rfvSerialNo.Enabled = true;
}
else
{
BindItemName();
drpItemName.SelectedValue = string.IsNullOrEmpty(drpItemName.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_ID"]);
//drpSerialNo.SelectedValue = string.IsNullOrEmpty(drpSerialNo.SelectedValue) ? "0" : Convert.ToString(drs[0]["ITEM_SERIALID"]);
ddlTyreType.Enabled = false; txtQty.Enabled = true; rfvddlTyreType.Enabled = false; txtQty.Text = "1";
drpSerialNo.Enabled = false; rfvSerialNo.Enabled = false; ddlTyreType.Enabled = false;
}
}
txtQty.Text = Convert.ToString(drs[0]["ITEM_QTY"]);
txtRate.Text = Convert.ToString(drs[0]["ITEM_RATE"]);
hidrowid.Value = Convert.ToString(drs[0]["id"]);
}
drpItemType.Focus();
}
else if (e.CommandName == "cmddelete")
{
DataTable dt = CreateDt();
foreach (DataRow rw in DtTemp.Rows)
{
int ridd = Convert.ToInt32(Convert.ToString(rw["id"]));
if (id != ridd)
{
ApplicationFunction.DatatableAddRow(dt, rw["id"], rw["ITEM_TYPE"], rw["ITEM_TYPEID"], rw["ITEM_SERIAL"],
rw["ITEM_SERIALID"], rw["TYRE_TYPE"], rw["TYRE_TYPEID"], rw["ITEM_QTY"], rw["ITEM_RATE"], rw["ITEM_AMOUNT"], rw["ITEM_NAME"], rw["ITEM_ID"]);
}
}
ViewState["dt"] = dt;
dt.Dispose();
this.BindGrid();
}
}
private void Populate(int AcntIdno)
{
LedgerAccountDAL objAcntMaster = new LedgerAccountDAL();
var objAcntMast = objAcntMaster.SelectById(AcntIdno);
var lst = objAcntMaster.CheckInvGen(AcntIdno);
var objDocHolder = objAcntMaster.SelectDocHolder(AcntIdno);
objAcntMaster = null;
if (objAcntMast != null)
{
hiddriverPopulate.Value = Convert.ToString(lst);
txtAccountPrtyName.Text = Convert.ToString(objAcntMast.Acnt_Name);
txtAccountPrtyNameHindi.Text = Convert.ToString(objAcntMast.AcntName_Hindi);
txtAddress1.Text = Convert.ToString(objAcntMast.Address1);
txtAddress2.Text = Convert.ToString(objAcntMast.Address2);
txtAccount.Text = Convert.ToString(objAcntMast.Account_No);
txtBankName.Text = Convert.ToString(objAcntMast.Bank_Name);
txtBranchName.Text = Convert.ToString(objAcntMast.Branch_Name);
txtIfscNo.Text = Convert.ToString(objAcntMast.Ifsc_Code);
txtagntCommision.Text = Convert.ToString(objAcntMast.Agnt_Commson);
ddlAccountType.SelectedValue = Convert.ToString(objAcntMast.Acnt_Type);
txtContEmail.Text = Convert.ToString(objAcntMast.Cont_Email);
if ((Convert.ToInt32(ddlAccountType.SelectedValue) == 3) || (Convert.ToInt32(ddlAccountType.SelectedValue) == 1))
{
txtcontPrsn.Enabled = false; txtContMob.Enabled = false; txtContEmail.Enabled = false; txtAddress1.Enabled = false;
txtAddress2.Enabled = false; ddlState.Enabled = false; ddlCity.Enabled = false; chkStatus.Enabled = false;
txtPinCode.Enabled = false; txtTin.Enabled = false; txtFax.Enabled = false; ddlCategory.Enabled = false;
rfvState.Enabled = false; rfvCity.Enabled = false; rfvpetroCompany.Enabled = false; rfvpetroCompany.Visible = false;
rfvCity.Visible = false; rfvState.Visible = false; SpanCityRefresh.Visible = false;
ddlState.SelectedIndex = 0; ddlCity.SelectedIndex = 0; ddlDistrict.SelectedIndex = 0;
}
else
{
ddlState.SelectedValue = Convert.ToString(objAcntMast.State_Idno);
this.BindCitywithStateId(Convert.ToInt32(objAcntMast.State_Idno));
if ((Convert.ToString(objAcntMast.City_Idno) != "") && (Convert.ToInt64(objAcntMast.City_Idno) > 0))
{
ddlCity.SelectedValue = Convert.ToString(objAcntMast.City_Idno);
}
}
ddlTitle.SelectedValue = Convert.ToString(objAcntMast.Titl_Idno);
if (Convert.ToInt32(ddlAccountType.SelectedValue) != 12)
{
DivlnkClaimDetails.Visible = false;
}
else
{
DivbtnDriver.Visible = false; DivlnkClaimDetails.Visible = true;
}
if (Convert.ToString(objAcntMast.Acnt_Type) == "9")
{
txtlicense.Text = Convert.ToString(objAcntMast.DrvLicnc_NO);
if (objAcntMast.DrvLNo_ExpDate != null)
{
txtExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy");
}
txtauthority.Text = Convert.ToString(objAcntMast.DrvAuthrty_Plc);
txtaccountno.Text = Convert.ToString(objAcntMast.DrvAcnt_No);
Drpgurenter.SelectedValue = Convert.ToString(objAcntMast.DrvGurntr_Idno);
chkVarified.Checked = Convert.ToBoolean(objAcntMast.DrvLNo_Verfd);
txtDriverSOF.Text = Convert.ToString(objAcntMast.DrvFather_Nm);
txtDriverAddress.Text = Convert.ToString(objAcntMast.Drv_Adres);
txtDriverMobileNo1.Text = Convert.ToString(objAcntMast.Drv_MobNo1);
txtDriverMobileNo2.Text = Convert.ToString(objAcntMast.Drv_MobNo2);
txtDriverBankName.Text = Convert.ToString(objAcntMast.DrvBankAc_Nm);
txtDriverBankAddrs.Text = Convert.ToString(objAcntMast.DrvBankAc_Adres);
txtDriverRTGC.Text = Convert.ToString(objAcntMast.DrvAc_RtgsCode);
txtDriverHazardousL.Text = Convert.ToString(objAcntMast.DrvHazardLic_No);
if (objAcntMast.DrvHazardLic_NoExpDt != null)
{
txtHazardousExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy");
}
ViewState["LincenceNo"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLicnc_NO)) ? "" : Convert.ToString(objAcntMast.DrvLicnc_NO);
ViewState["ExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_ExpDate)) ? "" : Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy");
ViewState["Authority"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAuthrty_Plc)) ? "" : Convert.ToString(objAcntMast.DrvAuthrty_Plc);
ViewState["Account"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAcnt_No)) ? "" : Convert.ToString(objAcntMast.DrvAcnt_No);
ViewState["Guarantor"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvGurntr_Idno)) ? "0" : Convert.ToString(objAcntMast.DrvGurntr_Idno);
ViewState["varified"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_Verfd)) ? "0" : Convert.ToString(objAcntMast.DrvLNo_Verfd);
ViewState["FatherName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvFather_Nm)) ? "" : Convert.ToString(objAcntMast.DrvFather_Nm);
ViewState["Address"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_Adres)) ? "" : Convert.ToString(objAcntMast.Drv_Adres);
ViewState["Mobile1"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo1)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo1);
ViewState["Mobile2"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo2)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo2);
ViewState["BankName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Nm)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Nm);
ViewState["BankAddress"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Adres)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Adres);
ViewState["RTGScode"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAc_RtgsCode)) ? "" : Convert.ToString(objAcntMast.DrvAc_RtgsCode);
ViewState["HazardousLicence"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_No)) ? "" : Convert.ToString(objAcntMast.DrvHazardLic_No);
ViewState["HazardousExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_NoExpDt)) ? "" : Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy");
}
//Other Charge.........
txtdetenPlantchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPlant_charg)) ? "0.00" :Convert.ToString(objAcntMast.detenPlant_charg);
txtdetenPortchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPort_charg)) ? "0.00" : Convert.ToString(objAcntMast.detenPort_charg);
txtcontainerchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Container_charg)) ? "0.00" : Convert.ToString(objAcntMast.Container_charg);
//
//ddlAccountType.Enabled = false;
ddlAccountSubGroup.SelectedValue = Convert.ToString(objAcntMast.ASubGrp_Idno);
ddlBalanceType.SelectedValue = Convert.ToString(objAcntMast.Bal_Type);
txtOpBal.Text = Convert.ToString(objAcntMast.Open_Bal);
chkServExmpt.Checked = Convert.ToBoolean(objAcntMast.ServTax_Exmpt);
txtcontPrsn.Text = Convert.ToString(objAcntMast.Cont_Person);
txtContMob.Text = Convert.ToString(objAcntMast.Cont_Mobile);
txtPinCode.Text = (Convert.ToString(objAcntMast.Pin_Code) == "0")? "" : Convert.ToString(objAcntMast.Pin_Code);
txtFax.Text = Convert.ToString(objAcntMast.Fax_No);
chkStatus.Checked = Convert.ToBoolean(objAcntMast.Status);
ddlCompany.SelectedValue = Convert.ToString(objAcntMast.PetrolComp_Idno);
ddlPrincComp.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objAcntMast.PComp_Idno)) ? "0" : Convert.ToString(objAcntMast.PComp_Idno);
txtPanNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Pan_No)) ? "" : Convert.ToString(objAcntMast.Pan_No);
txtLSTNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Lst_No)) ? "" : Convert.ToString(objAcntMast.Lst_No);
txtcstNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Cst_No)) ? "" : Convert.ToString(objAcntMast.Cst_No);
hidid.Value = Convert.ToString(objAcntMast.Acnt_Idno);
txtGST.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.LdgrGSTIN_No)) ? "" : Convert.ToString(objAcntMast.LdgrGSTIN_No);
txtShortName.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Short_Name)) ? "" : Convert.ToString(objAcntMast.Short_Name);
if (objDocHolder != null && objDocHolder.Count > 0)
{
dtTemp = CreateDt();
for (int counter = 0; counter < objDocHolder.Count; counter++)
{
string strDocName = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocName"));
string strRemark = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocRemark"));
string strImage = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocImage"));
ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strDocName, strRemark, strImage);
}
ViewState["DocumentHolderTable"] = dtTemp;
this.BindDocumentDataGrid();
}
ddlTitle.Focus();
}
}
public void FillGridValue()
{
string filename = String.Empty, filePath = String.Empty, VirtualBinaryImage = "";
decimal size = Math.Round(((decimal)fuPicture.PostedFile.ContentLength / (decimal)1024), 2);
if (size > 600)
{
lblimgError.Visible = true;
lblimgError.Text = "File size must not exceed 600 KB.";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true);
}
else
{
try
{
lblimgError.Visible = false;
string[] validFileTypes = { "bmp", "gif", "png", "jpg", "jpeg" };
HttpPostedFile File1 = fuPicture.PostedFile;
string ext = System.IO.Path.GetExtension(fuPicture.PostedFile.FileName);
bool isValidFile = false;
for (int i = 0; i < validFileTypes.Length; i++)
{
if (ext == "." + validFileTypes[i])
{
isValidFile = true;
break;
}
}
if (!isValidFile)
{
string strMsg = "Invalid File. Please upload a File with extension " + string.Join(",", validFileTypes);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
imgEmp.ImageUrl = "";
}
else
{
if (fuPicture.HasFile)
{
if (fuPicture.PostedFile.ContentLength < 5024000)
{
string subPath = "C:\\tmpImg"; // your code goes here
bool exists = System.IO.Directory.Exists(subPath);
if (!exists)
{
System.IO.Directory.CreateDirectory(subPath);
}
filename = Path.GetFileName(fuPicture.FileName);
filePath = subPath + "\\" + filename;
fuPicture.SaveAs(filePath);
byte[] byteArray = null;
HttpPostedFile file = (HttpPostedFile)fuPicture.PostedFile;
using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read))
{
byteArray = new byte[fs.Length];
int iBytesRead = fs.Read(byteArray, 0, (int)fs.Length);
if (byteArray != null && byteArray.Length > 0)
{
// Convert the byte into image
string base64String = Convert.ToBase64String(byteArray, 0, byteArray.Length);
VirtualBinaryImage = "data:image/png;base64," + base64String;
}
}
}
}
}
}
catch (Exception ex)
{
}
dtTemp = CreateDt();
dtTemp = (DataTable)ViewState["DocumentHolderTable"];
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
ApplicationFunction.DatatableAddRow(dtTemp, id, txtDocName.Text.Trim(), txtDocRemark.Text.Trim(), VirtualBinaryImage);
ViewState["DocumentHolderTable"] = dtTemp;
this.BindDocumentDataGrid();
txtDocName.Text = string.Empty;
txtDocRemark.Text = string.Empty;
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "ShowDocumentHolder()", true);
}
}
protected void lnkbtnSave_Click(object sender, EventArgs e)
{
string msg = "";
DateTime?ClaimDate = null;
ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
DateTime CurrentDate = System.DateTime.Now;
Int64 intAgainst = 0;
if (RDbSaleBill.Checked == true)
{
intAgainst = 0;
}
else
{
intAgainst = 1;
}
if (grdMain.Rows.Count > 0)
{
DTMain = CreateDt();
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno");
HiddenField hidSbillIdno = (HiddenField)row.FindControl("hidSbillIdno");
TextBox txtDefRemark = (TextBox)row.FindControl("txtDefRemark");
TextBox txtVchAppDetl = (TextBox)row.FindControl("txtVchAppDetl");
ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidSbillIdno.Value, txtDefRemark.Text, txtVchAppDetl.Text);
}
tblClaimHead objClaimHead = new tblClaimHead();
if (txtClaimDate.Text == "")
{
objClaimHead.ClaimHead_Date = null;
}
else
{
objClaimHead.ClaimHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text));
}
objClaimHead.Claim_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim());
objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim());
objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue);
objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue);
objClaimHead.Claim_Against = intAgainst;
objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue);
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (ViewState["ClaimHeadIdno"] != null)
{
objClaimHead.Date_Modified = System.DateTime.Now;
lnkbtnNew.Visible = false;
value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(ViewState["ClaimHeadIdno"].ToString()), DTMain);
objClaimFrmDAL = null;
}
else
{
objClaimHead.Date_Added = System.DateTime.Now;
value = objClaimFrmDAL.Insert(objClaimHead, DTMain);
objClaimFrmDAL = null;
}
if (ViewState["ClaimHeadIdno"] != null)
{
if (value > 0 && (ViewState["ClaimHeadIdno"] != null))
{
ShowMessage("Record Update successfully");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not Update");
tScope.Dispose();
}
}
else
{
if (value > 0 && (ViewState["ClaimHeadIdno"] == null))
{
ShowMessage("Record saved Successfully ");
Clear();
tScope.Complete();
}
else if (value == -1)
{
ShowMessageErr("Claim Number Already Exist");
tScope.Dispose();
}
else
{
ShowMessageErr("Record Not saved Successfully ");
tScope.Dispose();
}
}
}
}
else
{
ShowMessageErr("Please Search and Select Serial Number.");
return;
}
}
private void BindGrid()
{
try
{
DateTime?dtDateFrom = null;
DateTime?dtDateTo = null;
if (string.IsNullOrEmpty(txtDateFrom.Text.Trim()) == false)
{
dtDateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateFrom.Text.Trim()));
}
if (string.IsNullOrEmpty(txtDateTo.Text.Trim()) == false)
{
dtDateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDateTo.Text.Trim()));
}
TruckwiseRepDAL obj = new TruckwiseRepDAL();
DataTable DsGrdetail = new DataTable();
var detail = obj.SearchLorry(txtLorryNo.Text, dtDateFrom, dtDateTo, Convert.ToInt32(ddllorryType.SelectedValue), Convert.ToInt32(ddlReptype.SelectedValue));
if (detail != null && detail.Count > 0)
{
DsGrdetail = CreateDt();
ViewState["dt"] = DsGrdetail;
if (ViewState["dt"] != null)
{
for (int i = 0; i < detail.Count; i++)
{
ApplicationFunction.DatatableAddRow(DsGrdetail,
Convert.ToString(DataBinder.Eval(detail[i], "Lorry_No")),
Convert.ToDateTime(DataBinder.Eval(detail[i], "LicDate")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "RC")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "FitDate")).ToString("dd-MM-yyyy"),
Convert.ToDateTime(DataBinder.Eval(detail[i], "Insurance")).ToString("dd-MM-yyyy")
);
}
}
if (detail != null && detail.Count > 0)
{
ViewState["dt"] = DsGrdetail;
rows = detail.Count;
grdMain.DataSource = detail;
grdMain.DataBind();
imgBtnExcel.Visible = true;
lblTotalRecord.Text = string.Empty;
if (Convert.ToInt32(ddlReptype.SelectedValue) == 1)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = true;
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = true;
grdMain.Columns[5].Visible = true;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 2)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = true;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 3)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = true;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 4)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = true;
grdMain.Columns[5].Visible = false;
}
else if (Convert.ToInt32(ddlReptype.SelectedValue) == 5)
{
grdMain.Columns[0].Visible = true;
grdMain.Columns[1].Visible = true;
grdMain.Columns[2].Visible = false;
grdMain.Columns[3].Visible = false;
grdMain.Columns[4].Visible = false;
grdMain.Columns[5].Visible = true;
}
if (detail.Count <= 0)
{
lblTotalRecord.Text = "T. Record(s): 0";
imgBtnExcel.Visible = false;
}
else
{
lblTotalRecord.Text = "T. Record(s): " + rows;
imgBtnExcel.Visible = true;
}
}
else
{
lblTotalRecord.Text = "T. Record(s): 0";
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
else
{
lblTotalRecord.Text = "T. Record(s): 0";
grdMain.DataSource = null;
grdMain.DataBind();
imgBtnExcel.Visible = false;
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
protected void lnkbtnSubmit_OnClick(object sender, EventArgs e)
{
if (ddlItemName.SelectedIndex == 0)
{
ShowMessageErr("Please select Item."); ddlItemName.Focus(); return;
}
if (ddlLocation.SelectedIndex == 0)
{
ShowMessageErr("Please select Location."); ddlLocation.Focus(); return;
}
if (txtQty.Text == "")
{
ShowMessageErr("Enter Qty"); txtQty.Focus(); return;
}
if (txtOpenRate.Text == "")
{
ShowMessageErr("Enter Qty"); txtQty.Focus(); return;
}
string TotalAmount = string.Empty;
dtTemp = (DataTable)ViewState["dt"];
if (ViewState["ID"] != null)
{
foreach (DataRow dtrow in dtTemp.Rows)
{
if (Convert.ToString(dtrow["id"]) == Convert.ToString(ViewState["ID"].ToString()))
{
dtrow["YearIdno"] = ddlDateRange.SelectedValue;
dtrow["LocName"] = ddlLocation.SelectedItem.Text;
dtrow["LocIdno"] = ddlLocation.SelectedValue;
dtrow["ItemName"] = ddlItemName.SelectedItem.Text;
dtrow["ItemIdno"] = ddlItemName.SelectedValue;
dtrow["Qty"] = txtQty.Text.Trim();
dtrow["Rate"] = txtOpenRate.Text.Trim();
}
}
ViewState["ID"] = null;
}
else
{
dtTemp = (DataTable)ViewState["dt"];
if ((dtTemp != null) && (dtTemp.Rows.Count > 0))
{
foreach (DataRow row in dtTemp.Rows)
{
if (Convert.ToString(row["ItemIdno"]) == Convert.ToString(ddlItemName.SelectedValue) && Convert.ToString(row["LocIdno"]) == Convert.ToString(ddlLocation.SelectedValue))
{
string msg = "Item Already Entered for same location";
ddlItemName.Focus();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + msg + "')", true);
return;
}
}
}
Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1;
int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1;
string strYearIdno = string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : (ddlDateRange.SelectedValue);
string strItemName = ddlItemName.SelectedItem.Text.Trim();
string strItemIdno = string.IsNullOrEmpty(ddlItemName.SelectedValue) ? "0" : (ddlItemName.SelectedValue);
string strLocName = ddlLocation.SelectedItem.Text.Trim();
string strLocIdno = string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : (ddlLocation.SelectedValue);
string strQty = txtQty.Text.Trim();
string strRate = txtOpenRate.Text.Trim();
ApplicationFunction.DatatableAddRow(dtTemp, id, strYearIdno, strLocIdno, strLocName, strItemIdno, strItemName, strQty, strRate);
}
ViewState["dt"] = dtTemp;
this.BindGridT();
txtQty.Text = "";
txtOpenRate.Text = "";
ddlItemName.SelectedValue = "0";
ddlLocation.SelectedValue = "0";
}
