public void AccDelete()
{
OpenAccDAL objOpenStock = new OpenAccDAL();
Int64 intStck = 0; string strMsg = string.Empty;
DataTable DT = (DataTable)ViewState["dt"];
if (ViewState["dtDelete"] != null)
{
dtDelete = (DataTable)ViewState["dtDelete"];
}
if (dtDelete != null && dtDelete.Rows.Count > 0)
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
intStck = objOpenStock.Delete(dtDelete);
objOpenStock = null;
if (intStck > 0)
{
Tran.Complete();
strMsg = "Record updated successfully.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
}
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();
}
}
private void BindGrid()
{
OpenAccDAL objDAL = new OpenAccDAL();
var lstGridData = objDAL.SelectStckMastList(Convert.ToInt32(ddlDateRange.SelectedValue), Convert.ToInt64(ddlLocation.SelectedIndex) == 0 ? 0 : Convert.ToInt32(ddlLocation.SelectedValue));
objDAL = null;
if (lstGridData != null && lstGridData.Count > 0)
{
grdMain.DataSource = lstGridData;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count;
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;
imgBtnExcel.Visible = true;
}
else
{
grdMain.DataSource = null;
grdMain.DataBind();
lblTotalRecord.Text = "T. Record (s): " + "0";
lblcontant.Visible = false;
divpaging.Visible = false;
imgBtnExcel.Visible = false;
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
string strMsg = string.Empty;
OpenAccDAL objOpenStock = new OpenAccDAL();
Int64 intStck = 0;
DataTable DT = (DataTable)ViewState["dt"];
if (ViewState["dtDelete"] != null)
{
dtDelete = (DataTable)ViewState["dtDelete"];
}
if (DT != null && DT.Rows.Count > 0)
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
//if (string.IsNullOrEmpty(hidstckidno.Value) == true)
//{
intStck = objOpenStock.Insert(DT, dtDelete);
//}
//else
//{
// intStck = objOpenStock.Update(DT, Convert.ToInt64(hidstckidno.Value));
//}
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();
}
}
}
private void BindCity()
{
OpenAccDAL objTollMastDAL = new OpenAccDAL();
var lst = objTollMastDAL.BindCityAll();
ddlLocation.DataSource = lst;
ddlLocation.DataTextField = "City_Name";
ddlLocation.DataValueField = "City_Idno";
ddlLocation.DataBind();
ddlLocation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("< Choose Location >", "0"));
}
private void BindDropdown()
{
OpenAccDAL obj = new OpenAccDAL();
var itemname = obj.BindPurchaseItemName();
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 RecordCount()
{
OpenAccDAL objDAL = new OpenAccDAL();
Int64 lstGridData = objDAL.Count(Convert.ToInt64(ddlDateRange.SelectedValue));
objDAL = null;
if (lstGridData != null && lstGridData > 0)
{
lblTotalRecord.Text = "T. Record (s): " + lstGridData;
imgBtnExcel.Visible = false;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
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)
{
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");
OpenAccDAL objItemMastDAL = new OpenAccDAL();
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], "LocName")), Convert.ToString(DataBinder.Eval(lst[i], "ItemName")),
Convert.ToString(DataBinder.Eval(lst[i], "Qty")), Convert.ToString(DataBinder.Eval(lst[i], "Rate")),
Convert.ToString(DataBinder.Eval(lst[i], "Amount")));
}
if ((DtCsv != null) && (DtCsv.Rows.Count != 0))
{
DtCsv.Columns["LocName"].Caption = "Location";
DtCsv.Columns["ItemName"].ColumnName = "TyreName";
DtCsv.Columns["Qty"].Caption = "Qty";
DtCsv.Columns["Rate"].Caption = "Rate";
DtCsv.Columns["Amount"].Caption = "Amount";
DtCsv.Columns["LocName"].SetOrdinal(0);
DtCsv.Columns["TyreName"].SetOrdinal(1);
DtCsv.Columns["Qty"].SetOrdinal(2);
DtCsv.Columns["Rate"].SetOrdinal(3);
DtCsv.Columns["Amount"].SetOrdinal(4);
DtCsv.AcceptChanges();
ExportDataTableToCSV(DtCsv, Convert.ToString("OpeningItemDetails"));
Response.Redirect("ManageOpenStockAccessories.aspx");
}
}
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
Count = 0;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
dTotQty += Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Qty"));
dTotRate += Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Rate"));
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");
string LocIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "LocIdno"));
string ItemIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "ItemIdno"));
if (ItemIdno != "")
{
OpenAccDAL obj = new OpenAccDAL();
var ItemExist = obj.CheckItemExistInOtherMaster(Convert.ToInt32(ItemIdno), Convert.ToInt32(LocIdno));
if (ItemExist != null && ItemExist.Count > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
}
// end----
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lblQuantity = (Label)e.Row.FindControl("lblRecordCount");
lblQuantity.Text = Count.ToString();
}
}
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;
}
OpenAccDAL objOpenStockAccess = new OpenAccDAL();
string excelfilename = string.Empty;
try
{
using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required))
{
excelfilename = ApplicationFunction.UploadFileServerControl(FileUpload, "ExcelAccessories", "OpeningStockAccessories");
if ((System.IO.Path.GetExtension(excelfilename) == ".xls") || (System.IO.Path.GetExtension(excelfilename) == ".xlsx"))
{
DataTable dt = ReadExcelFile("~/ExcelAccessories/" + excelfilename);
Int64 value = 0;
OpenAccDAL clsOpngStck = new OpenAccDAL();
DataTable DtnotUpload = dt.Clone();
OpenAccDAL objItem = new OpenAccDAL();
for (int count = 0; count < dt.Rows.Count; count++)
{
var lst = objItem.GetItemDetailsExl(Convert.ToString(dt.Rows[i]["Item"]).Trim());
if (lst.Count <= 0)
{
ShowMessageErr(Convert.ToString(dt.Rows[i]["Item"].ToString()).Trim() + " Item Does Not Exist!");
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)
{
}
}
