private void Populate(int useridno) { UserDefaultDAL objUserDefaultDAL = new UserDefaultDAL(); var objUserDefault = objUserDefaultDAL.SelectById(useridno); objUserDefaultDAL = null; try { if (objUserDefault != null) { ddlState.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.StateId)) ? "0" : Convert.ToString(objUserDefault.StateId); this.ddlState_SelectedIndexChanged(null, null); ddlCity.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.CityId)) ? "0" : Convert.ToString(objUserDefault.CityId); //BindCity(Convert.ToInt32(ddlState.SelectedValue)); ddlFromCity.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.FromCity_idno)) ? "0" : Convert.ToString(objUserDefault.FromCity_idno); hidUsrDefaultID.Value = string.IsNullOrEmpty(Convert.ToString(objUserDefault.UserDefault_Idno)) ? "0" : Convert.ToString(objUserDefault.UserDefault_Idno); ddlDateRange.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.Year_idno)) ? "0" : Convert.ToString(objUserDefault.Year_idno); ddlSender.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.SenderIdno)) ? "0" : Convert.ToString(objUserDefault.SenderIdno); ddlItemName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.ItemIdno)) ? "0" : Convert.ToString(objUserDefault.ItemIdno); ddlunitname.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.UnitIdno)) ? "0" : Convert.ToString(objUserDefault.UnitIdno); drpUserNm.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.User_idno)) ? "0" : Convert.ToString(objUserDefault.User_idno); ddlTaxPaidBy.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.STax_Typ)) ? "0" : Convert.ToString(objUserDefault.STax_Typ); ddlGRType.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objUserDefault.Gr_Type)) ? "0" : Convert.ToString(objUserDefault.Gr_Type); } else { hidUsrDefaultID.Value = "0"; ddlFromCity.SelectedIndex = 0; ddlDateRange.SelectedIndex = ddlState.SelectedIndex = ddlCity.SelectedIndex = ddlunitname.SelectedIndex = ddlTaxPaidBy.SelectedIndex = ddlItemName.SelectedIndex = ddlGRType.SelectedIndex = 0; } } catch (Exception e) { } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { string strMsg = string.Empty; UserDefaultDAL ObjDAL = new UserDefaultDAL(); Int64 intUserDefaultIdno = 0; Int64 userId = 0; Int64 FromCity = 0; if (drpUserNm.SelectedIndex <= 0) { strMsg = "Select user Name!"; drpUserNm.Focus(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + strMsg + "')", true); return; } else { userId = Convert.ToInt64(drpUserNm.SelectedValue); } if (ddlFromCity.SelectedIndex <= 0) { strMsg = "Select From City!"; drpUserNm.Focus(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('" + strMsg + "')", true); return; } else { FromCity = Convert.ToInt64(ddlFromCity.SelectedValue); } if (Convert.ToInt32(hidUsrDefaultID.Value) > 0) { intUserDefaultIdno = ObjDAL.Update(userId, FromCity, Convert.ToInt64(ddlDateRange.SelectedValue), Convert.ToInt64((hidUsrDefaultID.Value) == "" ? "0" : hidUsrDefaultID.Value), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlSender.SelectedValue), Convert.ToInt64(ddlItemName.SelectedValue), Convert.ToInt64(ddlunitname.SelectedValue), Convert.ToInt32(ddlTaxPaidBy.SelectedValue), Convert.ToInt32(ddlGRType.SelectedValue)); } else { intUserDefaultIdno = ObjDAL.Insert(userId, FromCity, Convert.ToInt64(ddlDateRange.SelectedValue), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlSender.SelectedValue), Convert.ToInt64(ddlItemName.SelectedValue), Convert.ToInt64(ddlunitname.SelectedValue), Convert.ToInt32(ddlTaxPaidBy.SelectedValue), Convert.ToInt32(ddlGRType.SelectedValue)); } ObjDAL = null; if (intUserDefaultIdno > 0) { strMsg = "Record Save successfully."; } else { strMsg = "Record Update successfully."; } if (Convert.ToString(Session["UserClass"]) == "Admin") { ClearAllControl(); } else { Populate(Convert.ToInt32(Session["UserIdno"])); } ShowMessage(strMsg); }
private void BindCity() { BindDropdownDAL obj = new BindDropdownDAL(); var FrmCity = obj.BindLocFrom(); ddlFromCity.DataSource = FrmCity; ddlFromCity.DataTextField = "City_Name"; ddlFromCity.DataValueField = "City_Idno"; ddlFromCity.DataBind(); objUserDefaultDAL = null; ddlFromCity.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "0")); }
private void BindUSERs() { UserDefaultDAL obj = new UserDefaultDAL(); var lst = obj.SelectALLUsers(); drpUserNm.DataSource = lst; drpUserNm.DataTextField = "Emp_Name"; drpUserNm.DataValueField = "User_Idno"; drpUserNm.DataBind(); drpUserNm.Items.Insert(0, new ListItem("--Select--", "0")); //if (base.UserIdno != 1) //{ // drpUserNm.SelectedValue = Convert.ToString(Session["UserIdno"]); // drpUserNm.Enabled = false; //} if (drpUserNm.SelectedIndex == 0) { ddlCity.Items.Insert(0, new ListItem("--Select City--", "0")); ddlState.Items.Insert(0, new ListItem("--Select State--", "0")); } drpUserNm_SelectedIndexChanged(null, null); }