protected void lnkuomsave_Click(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
Int64 intUOMIdno = 0;
if (txtUOMNameu.Text != "")
{
intUOMIdno = objclsUOMMaster.Insert(txtUOMNameu.Text.Trim(), txtNameHindiu.Text.Trim(), txtDescriptionu.Text.Trim(), Convert.ToBoolean(chkStatusu.Checked), empIdno);
}
objclsUOMMaster = null;
if (intUOMIdno > 0)
{
strMsg = "Record saved successfully.";
ClearUOM();
BindItemUnit();
ddlItemUnit.SelectedValue = Convert.ToString(intUOMIdno);
ddlItemUnit.Focus();
}
else if (intUOMIdno < 0)
{
strMsg = "Record already exists.";
}
else
{
strMsg = "Record not saved.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
protected void lnkbtnUom_OnClick(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
Int64 intUOMIdno = 0;
intUOMIdno = objclsUOMMaster.Insert(txtUOMName.Text.Trim(), "", "", true, empIdno);
objclsUOMMaster = null;
if (intUOMIdno > 0)
{
txtUOMName.Text = string.Empty;
BindItemUnit();
strMsg = "Record saved successfully.";
}
else if (intUOMIdno < 0)
{
strMsg = "Record already exists.";
}
else
{
strMsg = "Record not saved.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
private void BindGrid()
{
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
var lstGridData = objclsUOMMaster.SelectForSearch(Convert.ToString(txtUOMName.Text.Trim()));
objclsUOMMaster = null;
if (lstGridData != null && lstGridData.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("S.No", typeof(string));
dt.Columns.Add("UOM Name", typeof(string));
dt.Columns.Add("UOM Description", typeof(string));
dt.Columns.Add("Status", typeof(string));
int c = 0;
for (int i = 0; i < lstGridData.Count; i++)
{
DataRow dr = dt.NewRow();
dr["S.No"] = ++c;
dr["UOM Name"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "UOMName"));
dr["UOM Description"] = Convert.ToString(DataBinder.Eval(lstGridData[i], "UOMDesc"));
if (Convert.ToBoolean(DataBinder.Eval(lstGridData[i], "Status")) == true)
{
dr["Status"] = "Active";
}
else
{
dr["Status"] = "Inactive";
}
dt.Rows.Add(dr);
}
if (dt != null && dt.Rows.Count > 0)
{
ViewState["Dt"] = dt;
}
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 Populate(int UOMIdno)
{
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
var objUOMMast = objclsUOMMaster.SelectById(UOMIdno);
objclsUOMMaster = null;
if (objUOMMast != null)
{
txtUOMName.Text = Convert.ToString(objUOMMast.UOM_Name);
txtNameHindi.Text = Convert.ToString(objUOMMast.UOMName_Hindi);
txtDescription.Text = Convert.ToString(objUOMMast.UOM_Desc);
chkStatus.Checked = Convert.ToBoolean(objUOMMast.Status);
hiduomidno.Value = Convert.ToString(objUOMMast.UOM_Idno);
txtUOMName.Focus();
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string strMsg = string.Empty;
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
Int64 intUOMIdno = 0;
if (string.IsNullOrEmpty(hiduomidno.Value) == true)
{
intUOMIdno = objclsUOMMaster.Insert(txtUOMName.Text.Trim(), txtNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToBoolean(chkStatus.Checked), empIdno);
}
else
{
intUOMIdno = objclsUOMMaster.Update(txtUOMName.Text.Trim(), txtNameHindi.Text.Trim(), txtDescription.Text.Trim(), Convert.ToBoolean(chkStatus.Checked), Convert.ToInt32(hiduomidno.Value), empIdno);
}
objclsUOMMaster = null;
if (intUOMIdno > 0)
{
if (string.IsNullOrEmpty(hiduomidno.Value) == false)
{
ShowMessage("Record updated successfully.");
}
else
{
ShowMessage("Record saved successfully.");
}
this.ClearControls();
lnkbtnNew.Visible = false;
}
else if (intUOMIdno < 0)
{
ShowMessageErr("Record already exists.");
}
else
{
if (string.IsNullOrEmpty(hiduomidno.Value) == false)
{
ShowMessageErr("Record not updated.");
}
else
{
ShowMessageErr("Record not saved.");
}
}
txtUOMName.Focus();
}
protected void grdMain_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ImageButton imgBtnStatus = (ImageButton)e.Row.FindControl("imgBtnStatus");
bool status = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "Status"));
// Used to hide Delete button if ItemgrpId exists in Item Master,Fleet Mgmt Item Master,Goods Received,Quotation, GR Preparation,Fleet Mgnt. Purchase Bill
LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete");
string UOMIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "UOMIdno"));
if (UOMIdno != "")
{
UOMMasterDAL obj = new UOMMasterDAL();
var ItemGrpExist = obj.CheckUOMExistInOtherMaster(Convert.ToInt32(UOMIdno));
if (ItemGrpExist != null && ItemGrpExist.Count > 0)
{
lnkbtnDelete.Visible = false;
}
else
{
lnkbtnDelete.Visible = true;
}
}
// end----
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("UOMMaster.aspx?UOMIdno=" + e.CommandArgument, true);
}
if (e.CommandName == "cmddelete")
{
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
Int32 intValue = objclsUOMMaster.Delete(Convert.ToInt32(e.CommandArgument));
objclsUOMMaster = null;
if (intValue > 0)
{
this.BindGrid();
strMsg = "Record deleted successfully.";
txtUOMName.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);
}
else if (e.CommandName == "cmdstatus")
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
int intUOMIdno = 0;
bool bStatus = false;
string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' });
if (strStatus.Length > 1)
{
intUOMIdno = Convert.ToInt32(strStatus[0]);
if (Convert.ToBoolean(strStatus[1]) == true)
{
bStatus = false;
}
else
{
bStatus = true;
}
UOMMasterDAL objclsUOMMaster = new UOMMasterDAL();
int value = objclsUOMMaster.UpdateStatus(intUOMIdno, bStatus, empIdno);
objclsUOMMaster = null;
if (value > 0)
{
this.BindGrid();
strMsg = "Status updated successfully.";
txtUOMName.Focus();
}
else
{
strMsg = "Status not updated.";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
}
}
txtUOMName.Focus();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.UrlReferrer == null)
{
base.AutoRedirect();
}
if (!Page.IsPostBack)
{
if (base.CheckUserRights(intFormId) == false)
{
Response.Redirect("PermissionDenied.aspx");
}
if (base.ADD == false)
{
lnkbtnSave.Visible = false;
}
if (base.View == false)
{
lblViewList.Visible = false;
}
txtReceiptDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
this.GetAllItems();
this.BindCity();
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obj1 = new ReceiptGoodsReceivedDAL();
var lst = obj1.SelectCityCombo();
obj1 = null;
drpBaseCity.DataSource = lst;
drpBaseCity.DataTextField = "City_Name";
drpBaseCity.DataValueField = "City_Idno";
drpBaseCity.DataBind();
drpBaseCity.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindCity(Convert.ToInt64(Session["UserIdno"]));
}
ReceiptGoodsReceivedDAL objChlnBookingDAL = new ReceiptGoodsReceivedDAL();
tblUserPref obj = objChlnBookingDAL.selectUserPref();
if (obj != null)
{
drpBaseCity.SelectedValue = Convert.ToString(obj.BaseCity_Idno);
}
drpBaseCity.SelectedValue = Convert.ToString(base.UserFromCity);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ReceiptGoodsReceivedDAL obja = new ReceiptGoodsReceivedDAL();
var SenderReceiver = obja.SelectAcntMastByType(2);
BindDropdownDAL objagent = new BindDropdownDAL();
var Agent = objagent.BindAgent();
obj = null;
drpSender.DataSource = SenderReceiver;
drpSender.DataTextField = "Acnt_Name";
drpSender.DataValueField = "Acnt_Idno";
drpSender.DataBind();
drpSender.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.BindSenderReceiverAgent();
}
drpSender.SelectedValue = Convert.ToString(base.Sender);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
ItemMasterDAL obja = new ItemMasterDAL();
var lst = obja.GetItems();
obj = null;
drpItemName.DataSource = lst;
drpItemName.DataTextField = "ItemName";
drpItemName.DataValueField = "ItemId";
drpItemName.DataBind();
drpItemName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllItems();
}
drpItemName.SelectedValue = Convert.ToString(base.ItemName);
if (Convert.ToString(Session["Userclass"]) == "Admin")
{
UOMMasterDAL obja = new UOMMasterDAL();
var lst = obja.GetUnit();
obj = null;
drpUnitName.DataSource = lst;
drpUnitName.DataTextField = "UOMName";
drpUnitName.DataValueField = "UOMId";
drpUnitName.DataBind();
drpUnitName.Items.Insert(0, new ListItem("--Select--", "0"));
}
else
{
this.GetAllUnit();
}
drpUnitName.SelectedValue = Convert.ToString(base.Unit);
//this.GetAllUnit();
this.BindDateRange();
ddlDateRange_SelectedIndexChanged(null, null);
ddlDateRange.SelectedIndex = 0;
drpBaseCity.Enabled = true;
this.GetReceiptNo();
if (Request.QueryString["q"] != null)
{
this.BindSenderReceiverAgentPopulate();
Populate(Convert.ToInt64(Request.QueryString["q"]));
hidgoodsreceivedid.Value = Convert.ToString(Request.QueryString["q"]);
btnNew.Visible = true;
lnkbtnNew.Visible = true;
ddlDateRange.Enabled = false; imgPrint.Visible = true;
}
else
{
lnkbtnNew.Visible = false;
ddlDateRange.Enabled = true;
imgPrint.Visible = false;
//this.BindSenderReceiverAgent();
}
txtWeight.Attributes.Add("onkeypress", "return allowOnlyFloatNumber(event);");
txtQty.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtSenderNo.Attributes.Add("onkeypress", "return allowOnlyNumber(event);");
txtReceiptDate.Attributes.Add("onkeypress", "return notAllowAnything(event);");
txtRemark.Attributes.Add("onkeypress", "return notAllowSpecialCharacters_Spaceallow(event);");
}
Int32 intYearIdno = Convert.ToInt32(ddlDateRange.SelectedValue);
}
