public static CustomerClass UpdateItem(CustomerClass model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "CustomerClass_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(model.CustomerClassID, model.CompanyID));
}
public static CustomerClassCollection Search(SearchFilter SearchKey)
{
CustomerClassCollection collection = new CustomerClassCollection();
using (var reader = SqlHelper.ExecuteReader("CustomerClass_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
{
while (reader.Read())
{
CustomerClass obj = new CustomerClass();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static CustomerClass GetItemByID(string CustomerClassID, int CompanyID)
{
CustomerClass item = new CustomerClass();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CustomerClassID", CustomerClassID),
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("CustomerClass_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static CustomerClass AddItem(CustomerClass model)
{
String result = String.Empty;
try
{
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "CustomerClass_Add", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
}
catch (Exception ObjEx)
{
}
return(GetItemByID(result, model.CompanyID));
}
public static CustomerClassCollection GetAllItem(int CompanyID)
{
CustomerClassCollection collection = new CustomerClassCollection();
var sqlParams = new SqlParameter[]
{
new SqlParameter("@CompanyID", CompanyID),
};
using (var reader = SqlHelper.ExecuteReader("CustomerClass_GetAll", sqlParams))
{
while (reader.Read())
{
CustomerClass obj = new CustomerClass();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
private static SqlParameter[] CreateSqlParameter(CustomerClass model)
{
return(new SqlParameter[]
{
new SqlParameter("@CompanyID", model.CompanyID),
new SqlParameter("@CustomerClassID", model.CustomerClassID),
new SqlParameter("@Descr", model.Descr),
new SqlParameter("@TermsID", model.TermsID),
new SqlParameter("@TaxZoneID", model.TaxZoneID),
new SqlParameter("@RequireTaxZone", model.RequireTaxZone),
new SqlParameter("@AvalaraCustomerUsageType", model.AvalaraCustomerUsageType),
new SqlParameter("@RequireAvalaraCustomerUsageType", model.RequireAvalaraCustomerUsageType),
new SqlParameter("@DefPaymentMethodID", model.DefPaymentMethodID),
new SqlParameter("@CuryID", model.CuryID),
new SqlParameter("@CuryRateTypeID", model.CuryRateTypeID),
new SqlParameter("@AllowOverrideCury", model.AllowOverrideCury),
new SqlParameter("@AllowOverrideRate", model.AllowOverrideRate),
new SqlParameter("@ARAcctID", model.ARAcctID),
new SqlParameter("@ARSubID", model.ARSubID),
new SqlParameter("@ContraARAcctID", model.ContraARAcctID),
new SqlParameter("@ContraARSubID", model.ContraARSubID),
new SqlParameter("@DiscountAcctID", model.DiscountAcctID),
new SqlParameter("@DiscountSubID", model.DiscountSubID),
new SqlParameter("@DiscTakenAcctID", model.DiscTakenAcctID),
new SqlParameter("@DiscTakenSubID", model.DiscTakenSubID),
new SqlParameter("@SalesAcctID", model.SalesAcctID),
new SqlParameter("@SalesSubID", model.SalesSubID),
new SqlParameter("@COGSAcctID", model.COGSAcctID),
new SqlParameter("@COGSSubID", model.COGSSubID),
new SqlParameter("@FreightAcctID", model.FreightAcctID),
new SqlParameter("@FreightSubID", model.FreightSubID),
new SqlParameter("@MiscAcctID", model.MiscAcctID),
new SqlParameter("@MiscSubID", model.MiscSubID),
new SqlParameter("@UnrealizedGainAcctID", model.UnrealizedGainAcctID),
new SqlParameter("@UnrealizedGainSubID", model.UnrealizedGainSubID),
new SqlParameter("@UnrealizedLossAcctID", model.UnrealizedLossAcctID),
new SqlParameter("@UnrealizedLossSubID", model.UnrealizedLossSubID),
new SqlParameter("@AutoApplyPayments", model.AutoApplyPayments),
new SqlParameter("@PrintStatements", model.PrintStatements),
new SqlParameter("@PrintCuryStatements", model.PrintCuryStatements),
new SqlParameter("@SendStatementByEmail", model.SendStatementByEmail),
new SqlParameter("@CreditLimit", model.CreditLimit),
new SqlParameter("@CreditRule", model.CreditRule),
new SqlParameter("@CreditDaysPastDue", model.CreditDaysPastDue),
new SqlParameter("@StatementCycleId", model.StatementCycleId),
new SqlParameter("@StatementType", model.StatementType),
new SqlParameter("@SmallBalanceAllow", model.SmallBalanceAllow),
new SqlParameter("@SmallBalanceLimit", model.SmallBalanceLimit),
new SqlParameter("@FinChargeApply", model.FinChargeApply),
new SqlParameter("@FinChargeID", model.FinChargeID),
new SqlParameter("@CountryID", model.CountryID),
new SqlParameter("@OverLimitAmount", model.OverLimitAmount),
new SqlParameter("@PrepaymentAcctID", model.PrepaymentAcctID),
new SqlParameter("@PrepaymentSubID", model.PrepaymentSubID),
new SqlParameter("@ShipVia", model.ShipVia),
new SqlParameter("@ShipComplete", model.ShipComplete),
new SqlParameter("@ShipTermsID", model.ShipTermsID),
new SqlParameter("@SalesPersonID", model.SalesPersonID),
new SqlParameter("@DiscountLimit", model.DiscountLimit),
//new SqlParameter("@GroupMask", model.GroupMask),
//new SqlParameter("@tstamp", model.tstamp),
new SqlParameter("@PrintInvoices", model.PrintInvoices),
new SqlParameter("@MailInvoices", model.MailInvoices),
new SqlParameter("@PrintDunningLetters", model.PrintDunningLetters),
new SqlParameter("@MailDunningLetters", model.MailDunningLetters),
new SqlParameter("@PriceClassID", model.PriceClassID),
new SqlParameter("@DefaultLocationCDFromBranch", model.DefaultLocationCDFromBranch),
new SqlParameter("@LocaleName", model.LocaleName),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@CreatedDate", model.CreatedDate),
});
}
private static CustomerClass GetItemFromReader(IDataReader dataReader)
{
CustomerClass objItem = new CustomerClass();
objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID");
objItem.CustomerClassID = SqlHelper.GetString(dataReader, "CustomerClassID");
objItem.Descr = SqlHelper.GetString(dataReader, "Descr");
objItem.TermsID = SqlHelper.GetString(dataReader, "TermsID");
objItem.TaxZoneID = SqlHelper.GetString(dataReader, "TaxZoneID");
objItem.RequireTaxZone = SqlHelper.GetBoolean(dataReader, "RequireTaxZone");
objItem.AvalaraCustomerUsageType = SqlHelper.GetString(dataReader, "AvalaraCustomerUsageType");
objItem.RequireAvalaraCustomerUsageType = SqlHelper.GetBoolean(dataReader, "RequireAvalaraCustomerUsageType");
objItem.DefPaymentMethodID = SqlHelper.GetString(dataReader, "DefPaymentMethodID");
objItem.CuryID = SqlHelper.GetString(dataReader, "CuryID");
objItem.CuryRateTypeID = SqlHelper.GetString(dataReader, "CuryRateTypeID");
objItem.AllowOverrideCury = SqlHelper.GetBoolean(dataReader, "AllowOverrideCury");
objItem.AllowOverrideRate = SqlHelper.GetBoolean(dataReader, "AllowOverrideRate");
objItem.ARAcctID = SqlHelper.GetInt(dataReader, "ARAcctID");
objItem.ARSubID = SqlHelper.GetInt(dataReader, "ARSubID");
objItem.ContraARAcctID = SqlHelper.GetInt(dataReader, "ContraARAcctID");
objItem.ContraARSubID = SqlHelper.GetInt(dataReader, "ContraARSubID");
objItem.DiscountAcctID = SqlHelper.GetInt(dataReader, "DiscountAcctID");
objItem.DiscountSubID = SqlHelper.GetInt(dataReader, "DiscountSubID");
objItem.DiscTakenAcctID = SqlHelper.GetInt(dataReader, "DiscTakenAcctID");
objItem.DiscTakenSubID = SqlHelper.GetInt(dataReader, "DiscTakenSubID");
objItem.SalesAcctID = SqlHelper.GetInt(dataReader, "SalesAcctID");
objItem.SalesSubID = SqlHelper.GetInt(dataReader, "SalesSubID");
objItem.COGSAcctID = SqlHelper.GetInt(dataReader, "COGSAcctID");
objItem.COGSSubID = SqlHelper.GetInt(dataReader, "COGSSubID");
objItem.FreightAcctID = SqlHelper.GetInt(dataReader, "FreightAcctID");
objItem.FreightSubID = SqlHelper.GetInt(dataReader, "FreightSubID");
objItem.MiscAcctID = SqlHelper.GetInt(dataReader, "MiscAcctID");
objItem.MiscSubID = SqlHelper.GetInt(dataReader, "MiscSubID");
objItem.UnrealizedGainAcctID = SqlHelper.GetInt(dataReader, "UnrealizedGainAcctID");
objItem.UnrealizedGainSubID = SqlHelper.GetInt(dataReader, "UnrealizedGainSubID");
objItem.UnrealizedLossAcctID = SqlHelper.GetInt(dataReader, "UnrealizedLossAcctID");
objItem.UnrealizedLossSubID = SqlHelper.GetInt(dataReader, "UnrealizedLossSubID");
objItem.AutoApplyPayments = SqlHelper.GetBoolean(dataReader, "AutoApplyPayments");
objItem.PrintStatements = SqlHelper.GetBoolean(dataReader, "PrintStatements");
objItem.PrintCuryStatements = SqlHelper.GetBoolean(dataReader, "PrintCuryStatements");
objItem.SendStatementByEmail = SqlHelper.GetBoolean(dataReader, "SendStatementByEmail");
objItem.CreditLimit = SqlHelper.GetDecimal(dataReader, "CreditLimit");
objItem.CreditRule = SqlHelper.GetString(dataReader, "CreditRule");
objItem.CreditDaysPastDue = SqlHelper.GetSmallInt(dataReader, "CreditDaysPastDue");
objItem.StatementCycleId = SqlHelper.GetString(dataReader, "StatementCycleId");
objItem.StatementType = SqlHelper.GetString(dataReader, "StatementType");
objItem.SmallBalanceAllow = SqlHelper.GetBoolean(dataReader, "SmallBalanceAllow");
objItem.SmallBalanceLimit = SqlHelper.GetDecimal(dataReader, "SmallBalanceLimit");
objItem.FinChargeApply = SqlHelper.GetBoolean(dataReader, "FinChargeApply");
objItem.FinChargeID = SqlHelper.GetString(dataReader, "FinChargeID");
objItem.CountryID = SqlHelper.GetString(dataReader, "CountryID");
objItem.OverLimitAmount = SqlHelper.GetDecimal(dataReader, "OverLimitAmount");
objItem.PrepaymentAcctID = SqlHelper.GetInt(dataReader, "PrepaymentAcctID");
objItem.PrepaymentSubID = SqlHelper.GetInt(dataReader, "PrepaymentSubID");
objItem.ShipVia = SqlHelper.GetString(dataReader, "ShipVia");
objItem.ShipComplete = SqlHelper.GetString(dataReader, "ShipComplete");
objItem.ShipTermsID = SqlHelper.GetString(dataReader, "ShipTermsID");
objItem.SalesPersonID = SqlHelper.GetInt(dataReader, "SalesPersonID");
objItem.DiscountLimit = SqlHelper.GetDecimal(dataReader, "DiscountLimit");
objItem.GroupMask = SqlHelper.GetBytes(dataReader, "GroupMask");
objItem.tstamp = SqlHelper.GetTimeSpan(dataReader, "tstamp");
objItem.PrintInvoices = SqlHelper.GetBoolean(dataReader, "PrintInvoices");
objItem.MailInvoices = SqlHelper.GetBoolean(dataReader, "MailInvoices");
objItem.PrintDunningLetters = SqlHelper.GetBoolean(dataReader, "PrintDunningLetters");
objItem.MailDunningLetters = SqlHelper.GetBoolean(dataReader, "MailDunningLetters");
objItem.PriceClassID = SqlHelper.GetString(dataReader, "PriceClassID");
objItem.DefaultLocationCDFromBranch = SqlHelper.GetBoolean(dataReader, "DefaultLocationCDFromBranch");
objItem.LocaleName = SqlHelper.GetString(dataReader, "LocaleName");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
{
objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
}
return(objItem);
}
