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);
}
