public Store.Common.MessageInfo ManageItemMaster(Store.UserInfo.BusinessObject.UserInfo objUserInfo, CommandMode cmdMode)
{
try
{
return(odlUserInfo.ManageUserInfo(objUserInfo, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
return(null);
}
}
void ManageUserInfo()
{
objUserInfo = new Store.UserInfo.BusinessObject.UserInfo();
oblUserInfo = new Store.UserInfo.BusinessLogic.UserInfo();
try
{
if (cmdMode == Store.Common.CommandMode.M)
{
objUserInfo.UserID = Convert.ToInt32(txtUserID.Text);
//objUserInfo.ModifiedBy = Convert.ToInt32(Session["UserId"]);
}
else
{
objUserInfo.UserID = 0;
//objUserInfo.CreatedBy = Convert.ToInt32(Session["UserId"]);
}
objUserInfo.UserName = Convert.ToString(txtUserName.Text);
objUserInfo.UserDisplayName = Convert.ToString(txtUserDisplayName.Text);
objUserInfo.TypeofUserID = Convert.ToInt32(ddlTypeofUserID.SelectedItem.Value);
objUserInfo.Address = Convert.ToString(txtAddress.Text);
objUserInfo.CityID = Convert.ToInt32(ddlCityID.SelectedItem.Value);
objUserInfo.StateID = Convert.ToInt32(ddlStateID.SelectedItem.Value);
objUserInfo.CountryID = Convert.ToInt32(ddlCountryID.SelectedItem.Value);
objUserInfo.PinID = Convert.ToInt32(txtPinID.Text);
objUserInfo.ConcernPerson = Convert.ToInt32(txtConcernPerson.Text);
objUserInfo.PhoneNo = Convert.ToInt32(txtPhoneNo.Text);
objUserInfo.MobileNo = Convert.ToInt32(txtMobileNo.Text);
objUserInfo.EmailID = Convert.ToString(txtEmailID.Text);
objUserInfo.WebsiteAddress = Convert.ToString(txtWebsiteAddress.Text);
if (cbIsActive.Checked)
{
objUserInfo.IsActive = 1;
}
else
{
objUserInfo.IsActive = 0;
}
objMessageInfo = oblUserInfo.ManageItemMaster(objUserInfo, cmdMode);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
}
finally
{
objUserInfo = null;
//objMessageInfo = null;
oblUserInfo = null;
}
}
public Store.Common.MessageInfo ManageUserInfo(Store.UserInfo.BusinessObject.UserInfo objUserInfo, CommandMode cmdMode)
{
string SQL = "";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManageUserInfo";
param.Add(new SQLParameter("@UserID", objUserInfo.UserID));
param.Add(new SQLParameter("@UserName", objUserInfo.UserName));
param.Add(new SQLParameter("@UserDisplayName", objUserInfo.UserDisplayName));
param.Add(new SQLParameter("@TypeofUserID", objUserInfo.TypeofUserID));
param.Add(new SQLParameter("@Address", objUserInfo.Address));
param.Add(new SQLParameter("@CityID", objUserInfo.CityID));
param.Add(new SQLParameter("@StateID", objUserInfo.StateID));
param.Add(new SQLParameter("@CountryID", objUserInfo.CountryID));
param.Add(new SQLParameter("@PinID", objUserInfo.PinID));
param.Add(new SQLParameter("@ConcernPerson", objUserInfo.ConcernPerson));
param.Add(new SQLParameter("@PhoneNo", objUserInfo.PhoneNo));
param.Add(new SQLParameter("@MobileNo", objUserInfo.MobileNo));
param.Add(new SQLParameter("@EmailID", objUserInfo.EmailID));
param.Add(new SQLParameter("@WebsiteAddress", objUserInfo.WebsiteAddress));
param.Add(new SQLParameter("@IsActive", objUserInfo.IsActive));
param.Add(new SQLParameter("@ReferenceID", objUserInfo.ReferenceID));
param.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, param);
if (dr.Read())
{
objMessageInfo = new Store.Common.MessageInfo();
objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]);
objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]);
objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]);
objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]);
objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]);
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
}
return(objMessageInfo);
}
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e)
{
cmdMode = CommandMode.D;
objUserInfo = new Store.UserInfo.BusinessObject.UserInfo();
oblUserInfo = new Store.UserInfo.BusinessLogic.UserInfo();
try
{
ImageButton btndetails = sender as ImageButton;
GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer;
objUserInfo.UserID = Convert.ToInt32(dgvUserInfo.DataKeys[gvrow.RowIndex].Value.ToString());
objUserInfo.UserName = "";
objUserInfo.UserDisplayName = "";
objUserInfo.TypeofUserID = 0;
objUserInfo.Address = "";
objUserInfo.CityID = 0;
objUserInfo.StateID = 0;
objUserInfo.CountryID = 0;
objUserInfo.PinID = 0;
objUserInfo.ConcernPerson = 0;
objUserInfo.PhoneNo = 0;
objUserInfo.MobileNo = 0;
objUserInfo.EmailID = "";
objUserInfo.WebsiteAddress = "";
objUserInfo.CreatedBy = 1;
objMessageInfo = oblUserInfo.ManageItemMaster(objUserInfo, cmdMode);
BindUserInfo();
updateUserBdInfo.Update();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true);
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
}
finally
{
objUserInfo = null;
objMessageInfo = null;
oblTypeOfUser = null;
}
}
public Store.UserInfo.BusinessObject.UserInfo GetAllUserInfo(int UserInfoID, int Flag, string FlagValue)
{
Store.UserInfo.BusinessObject.UserInfo objUserInfo = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_UserInfo";
paramList.Add(new SQLParameter("@UserInfoID", UserInfoID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objUserInfo = new BusinessObject.UserInfo();
if (dr.IsDBNull(dr.GetOrdinal("UserID")) == false)
{
objUserInfo.UserID = dr.GetInt32(dr.GetOrdinal("UserID"));
}
if (dr.IsDBNull(dr.GetOrdinal("UserName")) == false)
{
objUserInfo.UserName = dr.GetString(dr.GetOrdinal("UserName"));
}
if (dr.IsDBNull(dr.GetOrdinal("UserDisplayName")) == false)
{
objUserInfo.UserDisplayName = dr.GetString(dr.GetOrdinal("UserDisplayName"));
}
if (dr.IsDBNull(dr.GetOrdinal("TypeofUserID")) == false)
{
objUserInfo.TypeofUserID = dr.GetInt32(dr.GetOrdinal("TypeofUserID"));
}
if (dr.IsDBNull(dr.GetOrdinal("Address")) == false)
{
objUserInfo.Address = dr.GetString(dr.GetOrdinal("Address"));
}
if (dr.IsDBNull(dr.GetOrdinal("CityID")) == false)
{
objUserInfo.CityID = dr.GetInt32(dr.GetOrdinal("CityID"));
}
if (dr.IsDBNull(dr.GetOrdinal("StateID")) == false)
{
objUserInfo.StateID = dr.GetInt32(dr.GetOrdinal("StateID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CountryID")) == false)
{
objUserInfo.CountryID = dr.GetInt32(dr.GetOrdinal("CountryID"));
}
if (dr.IsDBNull(dr.GetOrdinal("PinID")) == false)
{
objUserInfo.PinID = dr.GetInt32(dr.GetOrdinal("PinID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ConcernPerson")) == false)
{
objUserInfo.ConcernPerson = dr.GetInt32(dr.GetOrdinal("ConcernPerson"));
}
if (dr.IsDBNull(dr.GetOrdinal("PhoneNo")) == false)
{
objUserInfo.PhoneNo = dr.GetInt32(dr.GetOrdinal("PhoneNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("MobileNo")) == false)
{
objUserInfo.MobileNo = dr.GetInt32(dr.GetOrdinal("MobileNo"));
}
if (dr.IsDBNull(dr.GetOrdinal("Address")) == false)
{
objUserInfo.Address = dr.GetString(dr.GetOrdinal("Address"));
}
if (dr.IsDBNull(dr.GetOrdinal("EmailID")) == false)
{
objUserInfo.EmailID = dr.GetString(dr.GetOrdinal("EmailID"));
}
if (dr.IsDBNull(dr.GetOrdinal("WebsiteAddress")) == false)
{
objUserInfo.WebsiteAddress = dr.GetString(dr.GetOrdinal("WebsiteAddress"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objUserInfo.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objUserInfo.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objUserInfo.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objUserInfo.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objUserInfo.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objUserInfo.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objUserInfo.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objUserInfo.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(UserInfo).FullName, 1);
}
return(objUserInfo);
}
