/// <summary> /// /// </summary> /// <returns></returns> public List <Entities.Client> GetAllClients() { var clients = new List <Entities.Client>(); DbCommand dbCommand = null; try { using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClients)) { using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { ClientAddress clientAddress = new ClientAddress(); var client = new Entities.Client { ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", 0), ClientTypeName = DRE.GetNullableString(reader, "client_type", null), ClientId = DRE.GetNullableInt32(reader, "client_id", 0), ClientCode = DRE.GetNullableString(reader, "client_code", null), ClientName = DRE.GetNullableString(reader, "client_name", null), PANNo = DRE.GetNullableString(reader, "pan_no", null), SrNo = DRE.GetNullableInt64(reader, "sr_no", null), ClientAddressess = clientAddress.GetAllClientAddressessByClientId(DRE.GetInt32(reader, "client_id")) }; clients.Add(client); } } } } catch (Exception ex) { throw ex; } finally { dbCommand = null; } return(clients); }
public Int32 SaveClient(List <Entities.Client> client) { var clientId = 0; var db = DBConnect.getDBConnection(); using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction transaction = conn.BeginTransaction()) { try { var clientAddressId = 0; if (client.Count > 0) { foreach (Entities.Client c in client) { if (c.ClientId == null || c.ClientId == 0) { var result = IsClientNameExists(c.ClientName); if (result == false) { clientId = AddClient(c, transaction); } else { clientId = -2; } } else if (c.ModifiedBy == null || c.ModifiedBy == 0) { clientId = UpdateClient(c, transaction); } else if (c.IsDeleted == true) { var result = DeleteClient(c, transaction); if (result) { clientId = (int)c.ClientId; } } if (clientId > 0) { foreach (Entities.ClientAddress ca in c.ClientAddressess) { ca.ClientId = clientId; ClientAddress clientAddress = new ClientAddress(); clientAddressId = clientAddress.SaveClientAddress(ca, transaction); } } } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { db = null; } } } return(clientId); }