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