/// <summary>
///
/// </summary>
/// <param name="clientAddress"></param>
/// <returns></returns>
public Int32 SaveClientAddress(Entities.ClientAddress clientAddress)
{
var clientAddressId = 0;
if (clientAddress.ClientAddressId == null || clientAddress.ClientAddressId == 0)
{
var result = IsClientAddresseeNameExists((int)clientAddress.ClientId, clientAddress.ClientAddressName);
if (result == false)
{
clientAddressId = AddClientAddress(clientAddress);
}
else
{
clientAddressId = -1;
}
}
else if (clientAddress.IsDeleted == true)
{
var result = DeleteClientAddress(clientAddress);
}
else if (clientAddress.ModifiedBy > 0 || clientAddress.ModifiedBy != null)
{
clientAddressId = UpdateClientAddress(clientAddress);
}
return(clientAddressId);
}
/// <summary>
///
/// </summary>
/// <param name="clientAddress"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public Int32 SaveClientAddress(Entities.ClientAddress clientAddress, DbTransaction transaction)
{
var clientAddressId = 0;
if (clientAddress.ClientAddressId == null || clientAddress.ClientAddressId == 0)
{
//var result = IsClientAddresseeNameExists((int)clientAddress.ClientId, clientAddress.ClientAddressName);
//if (result == false)
//{
clientAddressId = AddClientAddress(clientAddress, transaction);
//}
//else
//{
// clientAddressId = -1;
//}
}
else if (clientAddress.IsDeleted == true)
{
var result = DeleteClientAddress(clientAddress, transaction);
if (result)
{
clientAddressId = (int)clientAddress.ClientAddressId;
}
}
else if (clientAddress.ModifiedBy > 0 || clientAddress.ModifiedBy != null)
{
clientAddressId = UpdateClientAddress(clientAddress, transaction);
}
return(clientAddressId);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.ClientAddress> GetAllClientAddressessByClientId(Int32 clientId)
{
var clientAddresses = new List <Entities.ClientAddress>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClientAddressByClientId))
{
database.AddInParameter(dbCommand, "@client_id", DbType.Int32, clientId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
//var customerAndTransporterMapping = new CustomerAndTransporterMapping();
var clientAddress = new Entities.ClientAddress
{
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
//CustomerAndTransporterMapping = customerAndTransporterMapping.GetTransportersListByCustomerAddressId(DRE.GetInt32(reader, "client_address_id"))
};
clientAddresses.Add(clientAddress);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientAddresses);
}
public bool DeleteClientAddress(Entities.ClientAddress clientAddress, DbTransaction transaction)
{
bool isDeleted = false;
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteClientAddress))
{
database.AddInParameter(dbCommand, "@client_address_id", DbType.Int32, clientAddress.ClientAddressId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, clientAddress.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, clientAddress.DeletedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
var result = database.ExecuteNonQuery(dbCommand, transaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
dbCommand = null;
}
return(isDeleted);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.ClientAddress> GetAllClientAddressess()
{
var clientAddresses = new List <Entities.ClientAddress>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClientAddressess))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var clientAddress = new Entities.ClientAddress
{
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
clientAddresses.Add(clientAddress);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientAddresses);
}
private Int32 AddClientAddress(Entities.ClientAddress clientAddress, DbTransaction transaction)
{
var clientAddressId = 0;
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertClientAddress))
{
database.AddInParameter(dbCommand, "@client_id", DbType.Int32, clientAddress.ClientId == null || clientAddress.ClientId == 0 ? (object)DBNull.Value : clientAddress.ClientId);
database.AddInParameter(dbCommand, "@address_type_id", DbType.Int32, clientAddress.AddressTypeId == null || clientAddress.AddressTypeId == 0 ? (object)DBNull.Value : clientAddress.AddressTypeId);
database.AddInParameter(dbCommand, "@client_address_id", DbType.Int32, clientAddress.ClientAddressId == null || clientAddress.ClientAddressId == 0 ? (object)DBNull.Value : clientAddress.ClientAddressId);
database.AddInParameter(dbCommand, "@client_address_name", DbType.String, string.IsNullOrEmpty(clientAddress.ClientAddressName) ? (object)DBNull.Value : clientAddress.ClientAddressName);
database.AddInParameter(dbCommand, "@address", DbType.String, string.IsNullOrEmpty(clientAddress.Address) ? (object)DBNull.Value : clientAddress.Address);
database.AddInParameter(dbCommand, "@country_id", DbType.Int32, clientAddress.CountryId == null || clientAddress.CountryId == 0 ? (object)DBNull.Value : clientAddress.CountryId);
database.AddInParameter(dbCommand, "@state_id", DbType.Int32, clientAddress.StateId == null || clientAddress.StateId == 0 ? (object)DBNull.Value : clientAddress.StateId);
database.AddInParameter(dbCommand, "@city_id", DbType.Int32, clientAddress.CityId == null || clientAddress.CityId == 0 ? (object)DBNull.Value : clientAddress.CityId);
database.AddInParameter(dbCommand, "@area", DbType.String, string.IsNullOrEmpty(clientAddress.Area) ? (object)DBNull.Value : clientAddress.Area);
database.AddInParameter(dbCommand, "@pin_code", DbType.String, string.IsNullOrEmpty(clientAddress.PinCode) ? (object)DBNull.Value : clientAddress.PinCode);
database.AddInParameter(dbCommand, "@tel_no", DbType.String, string.IsNullOrEmpty(clientAddress.TelNo) ? (object)DBNull.Value : clientAddress.TelNo);
database.AddInParameter(dbCommand, "@fax_no", DbType.String, string.IsNullOrEmpty(clientAddress.FaxNo) ? (object)DBNull.Value : clientAddress.FaxNo);
database.AddInParameter(dbCommand, "@email_id", DbType.String, string.IsNullOrEmpty(clientAddress.EmailId) ? (object)DBNull.Value : clientAddress.EmailId);
database.AddInParameter(dbCommand, "@contact_nos", DbType.String, string.IsNullOrEmpty(clientAddress.ContactNos) ? (object)DBNull.Value : clientAddress.ContactNos);
database.AddInParameter(dbCommand, "@service_tax_no", DbType.String, string.IsNullOrEmpty(clientAddress.ServiceTaxNo) ? (object)DBNull.Value : clientAddress.ServiceTaxNo);
database.AddInParameter(dbCommand, "@vat_no", DbType.String, string.IsNullOrEmpty(clientAddress.VATNo) ? (object)DBNull.Value : clientAddress.VATNo);
database.AddInParameter(dbCommand, "@tin_no", DbType.String, string.IsNullOrEmpty(clientAddress.TINNo) ? (object)DBNull.Value : clientAddress.TINNo);
database.AddInParameter(dbCommand, "@pan_no", DbType.String, string.IsNullOrEmpty(clientAddress.PANNo) ? (object)DBNull.Value : clientAddress.PANNo);
database.AddInParameter(dbCommand, "@gst_no", DbType.String, string.IsNullOrEmpty(clientAddress.GSTNo) ? (object)DBNull.Value : clientAddress.GSTNo);
database.AddInParameter(dbCommand, "@created_by", DbType.Int32, clientAddress.CreatedBy);
database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, clientAddress.CreatedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
clientAddressId = database.ExecuteNonQuery(dbCommand, transaction);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
clientAddressId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
dbCommand = null;
}
return(clientAddressId);
}
/// <summary>
///
/// </summary>
/// <param name="clientAddressId"></param>
/// <returns></returns>
public Entities.ClientAddress GetClientAddressById(Int32 clientAddressId)
{
var clientAddress = new Entities.ClientAddress();
DbCommand dbCommand = null;
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetClientAddressById))
{
database.AddInParameter(dbCommand, "@client_address_id", DbType.Int32, clientAddressId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var _clientAddress = new Entities.ClientAddress
{
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
clientAddress = _clientAddress;
}
}
}
return(clientAddress);
}
/// <summary>
///
/// </summary>
/// <param name="clientAddressName"></param>
/// <returns></returns>
public List <Entities.ClientAddress> SearchClientAddressNameByClientAddressName(string clientAddressName)
{
var clientAddresses = new List <Entities.ClientAddress>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchClientAddressNameByClientAddressName))
{
database.AddInParameter(dbCommand, "@client_address_name", DbType.String, clientAddressName);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var clientAddress = new Entities.ClientAddress
{
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null)
};
clientAddresses.Add(clientAddress);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientAddresses);
}
public bool DeleteClientAddres(Entities.ClientAddress clientAddress)
{
return(_clientAddress.DeleteClientAddres(clientAddress));
}
public Int32 SaveClientAddress(Entities.ClientAddress clientAddress)
{
return(_clientAddress.SaveClientAddress(clientAddress));
}
