//added Mahesh Patel on 27-12-2018
public int GetUserPasswordLDM(LoginSchema objLoginSchema)
{
try
{
ds = new DataSet();
int password;
login_conn = new SqlConnection();
login_conn = SQLHelper.OpenConnection();
SqlParameter[] _param = new SqlParameter[1];
_param[0] = new SqlParameter("@UserName", SqlDbType.VarChar);
_param[0].Value = objLoginSchema.UserName;
_param[0].Size = 50;
SqlCommand command = new SqlCommand();
command.CommandText = "[uspGetUserLDMPassword]";
command.CommandTimeout = 5000;
command.CommandType = CommandType.StoredProcedure;
password = Convert.ToInt32(HelperCls.ExecuteScalar(login_conn, null, command.CommandType, command.CommandText, _param));
return(password);
}
catch (Exception ex)
{
throw ex;
}
finally
{
SQLHelper.CloseConnection(login_conn);
login_conn.Dispose();
}
}
