private void BindGrid()
{
Int32 intItemTypeIdno = Convert.ToInt32(ddlGroupType.SelectedValue);
string strItemName = Convert.ToString(txtItemName.Text.Trim());
Int64 strItemTyp = Convert.ToInt64(ddlItemType.SelectedValue);
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var lstGridData = objItemMast.SelectForSearch(intItemTypeIdno, strItemName, strItemTyp);
objItemMast = 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 BindItemType()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var lst = objItemMast.SelectItemType();
ddlItemType.DataSource = lst;
ddlItemType.DataTextField = "ItemType_Name";
ddlItemType.DataValueField = "ItemTpye_Idno";
ddlItemType.DataBind();
objItemMast = null;
ddlItemType.Items.Insert(0, new ListItem("-- Select Item Type --", "0"));
}
protected void ddlGroupType_SelectedIndexChanged(object sender, EventArgs e)
{
ItemMastPurDAL obj = new ItemMastPurDAL();
DataTable Dttemp = new DataTable();
Int64 Value = string.IsNullOrEmpty(Convert.ToString(ddlGroupType.SelectedValue)) ? 0 : Convert.ToInt64(ddlGroupType.SelectedValue);
Dttemp = obj.SelectType(ApplicationFunction.ConnectionString(), Value);
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
ddlAddType.SelectedValue = Dttemp.Rows[0]["IDNO"].ToString();
}
}
private void BindGroupType()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var objlist = objItemMast.SelectGroupType();
ddlGroupType.DataSource = objlist;
ddlGroupType.DataTextField = "IGrp_Name";
ddlGroupType.DataValueField = "IGrp_Idno";
ddlGroupType.DataBind();
objItemMast = null;
ddlGroupType.Items.Insert(0, new ListItem("--- Select Item ---", "0"));
}
private void BindActiveItemUnit()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var lst = objItemMast.SelectActiveUnitType();
objItemMast = null;
ddlItemUnit.DataSource = lst;
ddlItemUnit.DataTextField = "UOM_Name";
ddlItemUnit.DataValueField = "UOM_Idno";
ddlItemUnit.DataBind();
ddlItemUnit.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindTyreTypeALL()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var lst = objItemMast.SelectTyreTypeAll();
ddlTyreType.DataSource = lst;
ddlTyreType.DataTextField = "TyreType_Name";
ddlTyreType.DataValueField = "TyreType_Idno";
ddlTyreType.DataBind();
ddlTyreType.Items.Insert(0, new ListItem("--Select--", "0"));
objItemMast = null;
}
public void Countall()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
Int64 count = objItemMast.Countall();
if (count > 0)
{
lblTotalRecord.Text = "T. Record (s):" + count;
}
else
{
lblTotalRecord.Text = "T. Record (s): 0 ";
}
}
private void BindItemType()
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var lst = objItemMast.SelectItemType();
ddlAddType.DataSource = lst;
ddlAddType.DataTextField = "ItemType_Name";
ddlAddType.DataValueField = "ItemTpye_Idno";
ddlAddType.DataBind();
ddlItemGropForPopup.DataSource = lst;
ddlItemGropForPopup.DataTextField = "ItemType_Name";
ddlItemGropForPopup.DataValueField = "ItemTpye_Idno";
ddlItemGropForPopup.DataBind();
objItemMast = null;
}
/// <summary>
/// To Populate all controls
/// </summary>
/// <param name="ItemIdno"></param>
private void Populate(int ItemIdno)
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var objitmMast = objItemMast.SelectById(ItemIdno);
objItemMast = null;
if (objitmMast != null)
{
txtItemName.Text = Convert.ToString(objitmMast.Item_Name);
txtItemNameHindi.Text = Convert.ToString(objitmMast.ItemNamel_Hindi);
txtDescription.Text = Convert.ToString(objitmMast.Item_Desc);
ddlGroupType.SelectedValue = Convert.ToString(objitmMast.IGrp_Idno);
ddlItemUnit.SelectedValue = Convert.ToString(objitmMast.Unit_Idno);
if (!string.IsNullOrEmpty(Convert.ToString(objitmMast.ItemType)))
{
this.BindTyreTypeALL();
ddlAddType.SelectedValue = Convert.ToString(objitmMast.ItemType);
ddlAddType_OnSelectedIndexChanged(new Object(), EventArgs.Empty);
}
if (!string.IsNullOrEmpty(Convert.ToString(objitmMast.Tyre_Type)))
{
ddlTyreType.SelectedValue = Convert.ToString(objitmMast.Tyre_Type);
}
txtCompanyName.Text = Convert.ToString(objitmMast.Comp_Name);
txtModelName.Text = Convert.ToString(objitmMast.Model_Name);
TxtPurchaseRate.Text = Convert.ToDouble(objitmMast.Pur_Rate).ToString("N2");
txtVAT.Text = Convert.ToDouble(objitmMast.VATTax_Per).ToString("N2");
txtCST.Text = Convert.ToDouble(objitmMast.CSTTax_Per).ToString("N2");
txtsgst.Text = Convert.ToDouble(objitmMast.SGST).ToString("N2");
txtcgst.Text = Convert.ToDouble(objitmMast.CGST).ToString("N2");
txtigst.Text = Convert.ToDouble(objitmMast.IGST).ToString("N2");
txtitemmrp.Text = Convert.ToDouble(objitmMast.Item_MRP).ToString("N2");
chkStatus.Checked = Convert.ToBoolean(objitmMast.Status);
hidItemidno.Value = Convert.ToString(objitmMast.Item_Idno);
txtItemName.Focus();
}
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgBtnStatus = (ImageButton)e.Row.FindControl("imgBtnStatus");
LinkButton imgBtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
bool status = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "Status"));
//
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
int itemidno = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "ItemIdno"));
if (itemidno > 0)
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
var ItemExist = objItemMast.SelectSearch(Convert.ToInt32(itemidno));
if (ItemExist != null && ItemExist > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
imgBtnStatus.Visible = true;
if (status == false)
{
imgBtnStatus.ImageUrl = "~/Images/inactive.png";
}
else
{
imgBtnStatus.ImageUrl = "~/Images/active.png";
}
}
}
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
string strMsg = string.Empty;
if (e.CommandName == "cmdEdit")
{
Response.Redirect("ItemMast.aspx?ItemIdno=" + e.CommandArgument, true);
}
else if (e.CommandName == "cmdstatus")
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
int intitemIdno = 0;
bool bStatus = false;
string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' });
if (strStatus.Length > 1)
{
intitemIdno = Convert.ToInt32(strStatus[0]);
if (Convert.ToBoolean(strStatus[1]) == true)
{
bStatus = false;
}
else
{
bStatus = true;
}
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
int value = objItemMast.UpdateStatus(intitemIdno, bStatus, empIdno);
objItemMast = null;
if (value > 0)
{
this.BindGrid();
strMsg = "Status updated successfully.";
txtItemName.Focus();
}
else
{
strMsg = "Status not updated!";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
else if (e.CommandName == "cmddelete")
{
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
long intValue = objItemMast.Delete(Convert.ToInt32(e.CommandArgument));
objItemMast = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
ddlGroupType.Focus();
}
else
{
if (intValue == -1)
{
strMsg = "Record can not be deleted. It is in use!";
}
else
{
strMsg = "Record not deleted.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtItemName.Text) == true)
{
this.ShowMessageErr("Please Enter Item Name !"); txtItemName.Focus(); return;
}
else if (ddlGroupType.SelectedIndex == 0)
{
this.ShowMessageErr("Please Select Item Grp!"); ddlGroupType.Focus(); return;
}
else if (ddlItemUnit.SelectedIndex == 0)
{
this.ShowMessageErr("Please Select Item Unit!"); ddlItemUnit.Focus(); return;
}
else if (ddlTyreType.SelectedIndex == 0)
{
this.ShowMessageErr("Please Select Tyre Type!"); ddlTyreType.Focus(); return;
}
//else if (string.IsNullOrEmpty(txtitemmrp.Text) == true || (Convert.ToDouble(txtitemmrp.Text) <= 0))
//{
// this.ShowMessageErr("Please Enter Item MRP !"); txtitemmrp.Focus(); return;
//}
else if (string.IsNullOrEmpty(txtsgst.Text) == true)
{
this.ShowMessageErr("Please Enter SGST !"); txtsgst.Focus(); return;
}
else if (string.IsNullOrEmpty(txtcgst.Text) == true)
{
this.ShowMessageErr("Please Enter CGST !"); txtcgst.Focus(); return;
}
else if (string.IsNullOrEmpty(txtigst.Text) == true)
{
this.ShowMessageErr("Please Enter IGST !"); txtigst.Focus(); return;
}
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
ItemMastPurDAL objItemMast = new ItemMastPurDAL();
Int64 intItemIdno = 0;
Int64 ItemType = string.IsNullOrEmpty(ddlAddType.SelectedValue) ? 0 : Convert.ToInt64(ddlAddType.SelectedValue);
Int64 TyreType = string.IsNullOrEmpty(ddlTyreType.SelectedValue) ? 0 : Convert.ToInt64(ddlTyreType.SelectedValue);
Double sgst = string.IsNullOrEmpty(txtsgst.Text) ? 0 :Convert.ToDouble(txtsgst.Text.Trim());
Double cgst = string.IsNullOrEmpty(txtcgst.Text) ? 0 : Convert.ToDouble(txtcgst.Text.Trim());
Double igst = string.IsNullOrEmpty(txtigst.Text) ? 0 : Convert.ToDouble(txtigst.Text.Trim());
Double Itemmrp = string.IsNullOrEmpty(txtitemmrp.Text) ? 0 : Convert.ToDouble(txtitemmrp.Text.Trim());
if (string.IsNullOrEmpty(hidItemidno.Value) == true)
{
intItemIdno = objItemMast.Insert(txtItemName.Text.Trim(), txtItemNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToInt64(ddlGroupType.SelectedValue), Convert.ToInt64(ddlItemUnit.SelectedValue), Convert.ToDouble(TxtPurchaseRate.Text.Trim()), Convert.ToDouble(txtVAT.Text.Trim()), Convert.ToDouble(txtCST.Text.Trim()), Convert.ToBoolean(chkStatus.Checked), ItemType, TyreType, txtCompanyName.Text.Trim(), txtModelName.Text.Trim(), empIdno, sgst, cgst, igst, Itemmrp);
}
else
{
intItemIdno = objItemMast.Update(txtItemName.Text.Trim(), txtItemNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToInt64(ddlGroupType.SelectedValue), Convert.ToInt64(ddlItemUnit.SelectedValue), Convert.ToDouble(TxtPurchaseRate.Text.Trim()), Convert.ToDouble(txtVAT.Text.Trim()), Convert.ToDouble(txtCST.Text.Trim()), Convert.ToBoolean(chkStatus.Checked), Convert.ToInt32(hidItemidno.Value), ItemType, TyreType, txtCompanyName.Text.Trim(), txtModelName.Text.Trim(), empIdno, sgst, cgst, igst, Itemmrp);
}
objItemMast = null;
if (intItemIdno > 0)
{
if (string.IsNullOrEmpty(hidItemidno.Value) == false)
{
ShowMessage("Record updated successfully.");
}
else
{
ShowMessage("Record saved successfully.");
}
this.ClearControls();
lnkbtnNew.Visible = false;
}
else if (intItemIdno < 0)
{
ShowMessageErr("Record already exists!");
}
else
{
if (string.IsNullOrEmpty(hidItemidno.Value) == false)
{
ShowMessageErr("Record not updated!");
}
else
{
ShowMessageErr("Record not saved!");
}
}
txtItemName.Focus();
}
