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 BindGrid()
{
OpenTyreDAL objDrivMast = new OpenTyreDAL();
var lstGridData = objDrivMast.SelectForSearch(Convert.ToInt32(string.IsNullOrEmpty(ddlDateRange.SelectedValue) ? "0" : ddlDateRange.SelectedValue), Convert.ToInt32(string.IsNullOrEmpty(ddlLocation.SelectedValue) ? "0" : ddlLocation.SelectedValue));
objDrivMast = null;
if (lstGridData != null && lstGridData.Count > 0)
{
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
imgBtnExcel.Visible = true;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): 0 ";
imgBtnExcel.Visible = false;
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
private void BindCity()
{
OpenTyreDAL objMastDAL = new OpenTyreDAL();
var lst = objMastDAL.BindCityAll();
ddlLocation.DataSource = lst;
ddlLocation.DataTextField = "City_Name";
ddlLocation.DataValueField = "City_Idno";
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, new ListItem("< Choose City >", "0"));
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
Count = 0;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
OpenTyreDAL obj = new OpenTyreDAL();
int ICount = obj.ICount(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo")));
double amnt = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "OpenRate"));
dblNetAmnt = amnt + dblNetAmnt;
if (ICount > 0)
{
LinkButton lblDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
LinkButton lbledit = (LinkButton)e.Row.FindControl("lnkbtnEdit");
lblDelete.Enabled = false;
lblDelete.ToolTip = "Issued";
lbledit.Enabled = false;
lbledit.ToolTip = "Issued";
}
Count++;
// Used to hide Delete button if ItemgrpId exists in Rate Master,Goods Received, Quotation,GR Preparation,Commission Master
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
LinkButton lnkbtnEdit = (LinkButton)e.Row.FindControl("lnkbtnEdit");
string ItemIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "TyreIdno"));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo"))) ? "0" : Convert.ToString(DataBinder.Eval(e.Row.DataItem, "SerialNo"));
if (ItemIdno != "")
{
BindDropdownDAL obj1 = new BindDropdownDAL();
var ItemExist = obj1.CheckItemExistInOtherMaster(SerialNo);
if (ItemExist != null && ItemExist.Count > 0)
{
lnkbtnDelete.Visible = false;
lnkbtnEdit.Visible = false;
}
else
{
lnkbtnEdit.Visible = true;
lnkbtnDelete.Visible = true;
}
}
// end----
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblQuantity = (Label)e.Row.FindControl("lblRecordCount");
Label lblAmntTot = (Label)e.Row.FindControl("lbltotAmount");
lblQuantity.Text = Convert.ToDouble(grdMain.Rows.Count).ToString("N2");
//lblAmntTot.Text = dblNetAmnt.ToString("N2");
}
}
private void BindDropdownAll()
{
OpenTyreDAL obj = new OpenTyreDAL();
var itemname = obj.BindPurchaseItemNameAll();
obj = null;
ddlItemName.DataSource = itemname;
ddlItemName.DataTextField = "Item_Name";
ddlItemName.DataValueField = "Item_idno";
ddlItemName.DataBind();
ddlItemName.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
private void BindTyresize()
{
OpenTyreDAL obj = new OpenTyreDAL();
var tyresize = obj.Bindtyresize();
obj = null;
ddltyresize.DataSource = tyresize;
ddltyresize.DataTextField = "TyreSize";
ddltyresize.DataValueField = "TyreSize_Idno";
ddltyresize.DataBind();
ddltyresize.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0"));
}
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();
}
}
private void BindCity()
{
OpenTyreDAL obj = new OpenTyreDAL();
var lst = obj.BindCityAll();
if (lst != null && lst.Count > 0)
{
ddlLocation.DataSource = lst;
ddlLocation.DataTextField = "City_Name";
ddlLocation.DataValueField = "City_Idno";
ddlLocation.DataBind();
}
ddlLocation.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void RecordCount()
{
OpenTyreDAL objTyreMast = new OpenTyreDAL();
var Rec = objTyreMast.SelectForSearch(Convert.ToInt32(ddlDateRange.SelectedValue), 0);
objTyreMast = null;
if (Rec.Count > 0)
{
lblTotalRecord.Text = "T. Record (s): " + Rec.Count;
imgBtnExcel.Visible = false;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
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 Page_Load(object sender, EventArgs e)
{
ddlItemName.Focus();
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
txtSerialNo.Attributes.Add("onkeypress", "return allowAlphabetAndNumer(event);");
OpenTyreDAL objMast = new OpenTyreDAL();
this.BindCity();
this.BindDateRange();
this.BindTyresize();
ddlDateRange.SelectedValue = Convert.ToString(base.UserDateRng);
ddlDateRange.SelectedIndex = 0;
ddlDateRange_SelectedIndexChanged(null, null);
dtTemp = dtDelete = CreateDt();
ViewState["dt"] = dtTemp;
ViewState["dtDelete"] = dtDelete;
//if (Request.QueryString["OpenIdno"] != null)
//{
// this.BindDropdownAll();
// this.Populate(Convert.ToInt32(Request.QueryString["OpenIdno"]));
// hidstckidno.Value = Convert.ToString(Request.QueryString["OpenIdno"]);
// lnkbtnNew.Visible = true;
//}
//else
//{
BindDropdown();
// lnkbtnNew.Visible = false;
// }
ddlDateRange.Focus();
}
}
protected void lnkbtnUpload_OnClick(object sender, EventArgs e)
{
string msg = string.Empty;
if (!FileUpload.HasFile)
{
FileUpload.Focus();
msg = "Please Select Excel File!";
ShowMessageErr(msg);
return;
}
if (ddlDateRange.SelectedValue == "0")
{
ddlDateRange.Focus();
msg = "Please Select Date Range!";
ShowMessageErr(msg);
return;
}
if (ddlLocation.SelectedValue == "0")
{
ddlLocation.Focus();
msg = "Please Select Location!";
ShowMessageErr(msg);
return;
}
OpenTyreDAL objOpenStockAccess = new OpenTyreDAL();
string excelfilename = string.Empty;
try
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
excelfilename = ApplicationFunction.UploadFileServerControl(FileUpload, "ExcelTyre", "OpeningStockAccessories");
if ((System.IO.Path.GetExtension(excelfilename) == ".xls") || (System.IO.Path.GetExtension(excelfilename) == ".xlsx"))
{
DataTable dt = ReadExcelFile("~/ExcelTyre/" + excelfilename);
Int64 value = 0;
OpenTyreDAL clsOpngStck = new OpenTyreDAL();
DataTable DtnotUpload = dt.Clone();
OpenTyreDAL objItem = new OpenTyreDAL();
for (int count = 0; count < dt.Rows.Count; count++)
{
var lst = objItem.GetItemDetailsExl(Convert.ToString(dt.Rows[count]["TyreName"]).Trim());
if (lst.Count <= 0)
{
ShowMessageErr(Convert.ToString(dt.Rows[count]["TyreName"].ToString()).Trim() + " Item Does Not Exist!");
return;
}
else
{
string Type = dt.Rows[count]["Type"].ToString();
if (Type == "New" || Type == "Old" || Type == "Retrieted")
{
string Type_Idno = (Type == "New") ? "1" : (Type == "Old") ? "2" : "3";
dt.Rows[count]["Type_Idno"] = Type_Idno;
}
else
{
ShowMessageErr(Convert.ToString(dt.Rows[count]["Type"].ToString()).Trim() + " Type Does Not Exist of " + dt.Rows[count]["TyreName"].ToString() + " Item!");
return;
}
}
}
int dttruncate = objOpenStockAccess.TurncatePartsAccessoriesFromExcel(ApplicationFunction.ConnectionString());
value = clsOpngStck.InsertPartsByExcel(dt, ApplicationFunction.ConnectionString());
BindGridDB();
}
else
{
msg = "Excel File Format Not Supported!";
ShowMessageErr(msg);
return;
}
}
}
catch (Exception Ex)
{
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
string strMsg = string.Empty;
OpenTyreDAL objOpenStock = new OpenTyreDAL();
Int64 intStck = 0;
int yearId = Convert.ToInt32(ddlDateRange.SelectedValue);
int locId = Convert.ToInt32(ddlLocation.SelectedValue);
int ItemId = Convert.ToInt32(ddlItemName.SelectedValue);
int TyreSizeId = Convert.ToInt32(ddltyresize.SelectedValue);
DataTable DT = (DataTable)ViewState["dt"];
if ((DT != null && DT.Rows.Count > 0) || (ViewState["dtDelete"] != null))
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
if (ViewState["dtDelete"] != null)
{
dtDelete = (DataTable)ViewState["dtDelete"];
}
if (string.IsNullOrEmpty(hidstckidno.Value) == true)
{
intStck = objOpenStock.Insert(DT, yearId, ItemId, locId, dtDelete);
}
// this is commented b/c update mode not in use
//else
//{
// intStck = objOpenStock.Update(DT, Convert.ToInt64(hidstckidno.Value), yearId, ItemId, locId);
//}
objOpenStock = null;
if (intStck > 0)
{
if (string.IsNullOrEmpty(hidstckidno.Value) == false)
{
Tran.Complete();
strMsg = "Record updated successfully.";
}
else
{
Tran.Complete();
strMsg = "Record saved successfully.";
}
ClearControls();
}
else
{
if (string.IsNullOrEmpty(hidstckidno.Value) == false)
{
Tran.Dispose();
strMsg = "Record not updated.";
}
else
{
Tran.Dispose();
strMsg = "Record not saved.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
ddlLocation.Focus();
}
}
}
