/// <summary>
/// DropDownForClient
/// Calls [usp_dropdown_Terms_for_Client]
/// </summary>
public override List <TermsDetails> DropDownForClient(System.Int32?clientId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_dropdown_Terms_for_Client", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <TermsDetails> lst = new List <TermsDetails>();
while (reader.Read())
{
TermsDetails obj = new TermsDetails();
obj.TermsId = GetReaderValue_Int32(reader, "TermsId", 0);
obj.TermsName = GetReaderValue_String(reader, "TermsName", "");
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Termss", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
/// <summary>
/// GetListForClient
/// Calls [usp_selectAll_Terms_for_Client]
/// </summary>
public override List <TermsDetails> GetListForClient(System.Int32?clientId, System.Int32?pageIndex, System.Int32?pageSize)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_selectAll_Terms_for_Client", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = pageIndex;
cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = pageSize;
cn.Open();
DbDataReader reader = ExecuteReader(cmd);
List <TermsDetails> lst = new List <TermsDetails>();
while (reader.Read())
{
TermsDetails obj = new TermsDetails();
obj.TermsId = GetReaderValue_Int32(reader, "TermsId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.Days = GetReaderValue_Int32(reader, "Days", 0);
obj.TermsName = GetReaderValue_String(reader, "TermsName", "");
obj.Buy = GetReaderValue_Boolean(reader, "Buy", false);
obj.Sell = GetReaderValue_Boolean(reader, "Sell", false);
obj.InAdvance = GetReaderValue_Boolean(reader, "InAdvance", false);
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
//[001] code start
obj.IsApplyBankFee = GetReaderValue_Boolean(reader, "IsApplyBankFee", false);
obj.BankFee = GetReaderValue_NullableDouble(reader, "BankFee", null);
//[001] code end
//[002] code start
obj.IsApplyPOBankFee = GetReaderValue_Boolean(reader, "IsApplyPOBankFee", false);
obj.POBankFee = GetReaderValue_NullableDouble(reader, "POBankFee", null);
//[002] code end
lst.Add(obj);
obj = null;
}
return(lst);
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Terms", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
private static Terms PopulateFromDBDetailsObject(TermsDetails obj)
{
Terms objNew = new Terms();
objNew.TermsId = obj.TermsId;
objNew.ClientNo = obj.ClientNo;
objNew.Days = obj.Days;
objNew.TermsName = obj.TermsName;
objNew.Buy = obj.Buy;
objNew.Sell = obj.Sell;
objNew.InAdvance = obj.InAdvance;
objNew.Inactive = obj.Inactive;
objNew.UpdatedBy = obj.UpdatedBy;
objNew.DLUP = obj.DLUP;
objNew.RowNum = obj.RowNum;
return(objNew);
}
//[001] code end
/// <summary>
/// Get
/// Calls [usp_select_Terms]
/// </summary>
public override TermsDetails Get(System.Int32?termsId)
{
SqlConnection cn = null;
SqlCommand cmd = null;
try {
cn = new SqlConnection(this.ConnectionString);
cmd = new SqlCommand("usp_select_Terms", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add("@TermsId", SqlDbType.Int).Value = termsId;
cn.Open();
DbDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
//return GetTermsFromReader(reader);
TermsDetails obj = new TermsDetails();
obj.TermsId = GetReaderValue_Int32(reader, "TermsId", 0);
obj.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0);
obj.Days = GetReaderValue_Int32(reader, "Days", 0);
obj.TermsName = GetReaderValue_String(reader, "TermsName", "");
obj.Buy = GetReaderValue_Boolean(reader, "Buy", false);
obj.Sell = GetReaderValue_Boolean(reader, "Sell", false);
obj.InAdvance = GetReaderValue_Boolean(reader, "InAdvance", false);
obj.Inactive = GetReaderValue_Boolean(reader, "Inactive", false);
obj.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null);
obj.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue);
return(obj);
}
else
{
return(null);
}
} catch (SqlException sqlex) {
//LogException(sqlex);
throw new Exception("Failed to get Terms", sqlex);
} finally {
cmd.Dispose();
cn.Close();
cn.Dispose();
}
}
