public Store.Common.MessageInfo ManageItemMaster(Store.Login.BusinessObject.Login objLogin, CommandMode cmdMode)
{
try
{
return(odlLogin.ManageLogin(objLogin, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Login).FullName, 1);
return(null);
}
}
public Store.Common.MessageInfo ManageLogin(Store.Login.BusinessObject.Login objLogin, CommandMode cmdMode)
{
string SQL = "USP_ManageLogin";
ParameterList param = new ParameterList();
DataTableReader dr;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManageItemMeasurementLogin";
param.Add(new SQLParameter("@LoginID", objLogin.LoginID));
param.Add(new SQLParameter("@UserID", objLogin.UserID));
param.Add(new SQLParameter("@Password", objLogin.Password));
param.Add(new SQLParameter("@OldPassword", objLogin.OldPassword));
param.Add(new SQLParameter("@IsActive", objLogin.IsActive));
param.Add(new SQLParameter("@LastLoginDate", objLogin.LastLoginDate));
param.Add(new SQLParameter("@UserTypeID", objLogin.UserTypeID));
param.Add(new SQLParameter("@UserId", objLogin.CreatedBy));
param.Add(new SQLParameter("@ReferenceID", objLogin.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(Login).FullName, 1);
}
return(objMessageInfo);
}
public Store.Login.BusinessObject.Login GetAllLogin(int LoginID, int Flag, string FlagValue)
{
Store.Login.BusinessObject.Login objLogin = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
SQL = "proc_Login";
paramList.Add(new SQLParameter("@LoginID", LoginID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objLogin = new BusinessObject.Login();
if (dr.IsDBNull(dr.GetOrdinal("LoginID")) == false)
{
objLogin.LoginID = dr.GetInt32(dr.GetOrdinal("LoginID"));
}
if (dr.IsDBNull(dr.GetOrdinal("UserID")) == false)
{
objLogin.UserID = dr.GetInt32(dr.GetOrdinal("UserID"));
}
if (dr.IsDBNull(dr.GetOrdinal("Password")) == false)
{
objLogin.Password = dr.GetString(dr.GetOrdinal("Password"));
}
if (dr.IsDBNull(dr.GetOrdinal("OldPassword")) == false)
{
objLogin.OldPassword = dr.GetString(dr.GetOrdinal("OldPassword"));
}
if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false)
{
objLogin.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive"));
}
if (dr.IsDBNull(dr.GetOrdinal("UserTypeID")) == false)
{
objLogin.UserTypeID = dr.GetInt32(dr.GetOrdinal("UserTypeID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false)
{
objLogin.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID"));
}
if (dr.IsDBNull(dr.GetOrdinal("LastLoginDate")) == false)
{
objLogin.LastLoginDate = dr.GetDateTime(dr.GetOrdinal("LastLoginDate"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false)
{
objLogin.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false)
{
objLogin.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false)
{
objLogin.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy"));
}
if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false)
{
objLogin.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn"));
}
if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false)
{
objLogin.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID"));
}
dr.Close();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Login).FullName, 1);
}
return(objLogin);
}
