public static ClientTypeDto ToDto(this ClientTypeEntity clientType) { return(new ClientTypeDto() { ClientTypeId = clientType.ClientTypeId, MinutePrice = clientType.MinutePrice, SMSPrice = clientType.SMSPrice, TypeName = clientType.TypeName //Clients=clientType.Clients.Select(c=>c.ToDto()).ToList() }); }
public int UpdateClientType(ClientTypeEntity oClientTypeEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("UPDATE tblclientType SET ClientTypeCode='" + oClientTypeEntity.ClientTypeCode + "',ClientTypeDetais='" + oClientTypeEntity.ClientTypeDetais + "',ClientTypeChargePercentage='" + oClientTypeEntity.ClientTypeChargePercentage + "',ClientTypeRemarks='" + oClientTypeEntity.ClientTypeRemarks + "', ClientTypeLastModifiedBy ='" + oClientTypeEntity.ClientTypeLastModifiedBy + "' WHERE ClientTypeID=" + oClientTypeEntity.ClientTypeID, con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int DeleteClientType(ClientTypeEntity oClientTypeEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("DELETE FROM tblClientType WHERE ClientTypeID=" + oClientTypeEntity.ClientTypeID, con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public int InsertClientType(ClientTypeEntity oClientTypeEntity) { con = oConnectionDatabase.DatabaseConnection(); int i = 0; cmd = new SqlCommand("INSERT INTO tblClientType (ClientTypeCode,ClientTypeDetais,ClientTypeRemarks,ClientTypeChargePercentage,ClientTypeCreateBy,ClientTypeLastModifiedBy) VALUES('" + oClientTypeEntity.ClientTypeCode + "','" + oClientTypeEntity.ClientTypeDetais + "','" + oClientTypeEntity.ClientTypeRemarks + "','" + oClientTypeEntity.ClientTypeChargePercentage + "','" + oClientTypeEntity.ClientTypeCreateBy + "','" + oClientTypeEntity.ClientTypeLastModifiedBy + "')", con); try { cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); i = 1; } catch { } con.Close(); return(i); }
public async Task GetClientTypes() { var options = TestHelper.GetDbContext("GetClientTypes"); //Given var lkp1 = new ClientTypeEntity { Id = Guid.NewGuid(), Name = "A", Code = "aa", DisplayOrder = 1 }; var lkp2 = new ClientTypeEntity { Id = Guid.NewGuid(), Name = "B", Code = "bb", DisplayOrder = 2 }; var lkp3 = new ClientTypeEntity { Id = Guid.NewGuid(), Name = "C", Code = "cc", DisplayOrder = 3 }; using (var context = new DataContext(options)) { //Jumbled order context.ClientType.Add(lkp2); context.ClientType.Add(lkp1); context.ClientType.Add(lkp3); context.SaveChanges(); } using (var context = new DataContext(options)) { var service = new ClientLookupService(context); //When var actual = await service.GetClientTypes(); //Then Assert.Equal(3, actual.Count); var actual1 = actual[0]; Assert.Equal(lkp1.Id, actual1.Id); Assert.Equal(lkp1.Name, actual1.Name); Assert.Equal(lkp1.Code, actual1.Code); var actual2 = actual[1]; Assert.Equal(lkp2.Id, actual2.Id); var actual3 = actual[2]; Assert.Equal(lkp3.Id, actual3.Id); } }
public static ClientTypeEntity InsertClientTypeUnknown(DbContextOptions <DataContext> options) { var type = new ClientTypeEntity { Id = ClientType.CLIENT_TYPE_UNKNOWN_ENTITY, Name = "Unknown Entity", Code = "unknown" }; using (var context = new DataContext(options)) { context.ClientType.Add(type); context.SaveChanges(); }; return(type); }
public static ClientTypeEntity InsertClientTypeIndividual(DbContextOptions <DataContext> options) { var type = new ClientTypeEntity { Id = ClientType.CLIENT_TYPE_INDIVIDUAL, Name = "Individual", Code = "individual" }; using (var context = new DataContext(options)) { context.ClientType.Add(type); context.SaveChanges(); }; return(type); }