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);
}
