public AddCompanyMasterQueryModel AddCompanyMaster(AddCompanyMasterCommandModel addCompanyMasterCommandModel)
{
using (var connection = new DbConnectionProvider().CreateConnection())
{
connection.Open();
var companyMasterInsertCommand = new CompanyMasterInsertCommand {
Connection = connection
};
companyMasterInsertCommand.Execute(addCompanyMasterCommandModel);
}
return(new AddCompanyMasterQueryModel());
}
public void Execute(AddCompanyMasterCommandModel addCompanyMaster)
{
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspAddCompanyMaster]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@CompanyCode", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.CompanyCode));
sqlCommand.Parameters.Add(AddParameter("@CompanyName", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyName));
sqlCommand.Parameters.Add(AddParameter("@CompanyAddress1", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyAddress1));
sqlCommand.Parameters.Add(AddParameter("@CompanyAddress2", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyAddress2));
sqlCommand.Parameters.Add(AddParameter("@CompanyCity", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyCity));
sqlCommand.Parameters.Add(AddParameter("@CompanyPincode", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyPincode));
sqlCommand.Parameters.Add(AddParameter("@CompanyPhone", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyPhone));
sqlCommand.Parameters.Add(AddParameter("@CompanyFax", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyFax));
sqlCommand.Parameters.Add(AddParameter("@CompanyEmail", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyEmail));
sqlCommand.Parameters.Add(AddParameter("@CompanyWeb", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyWeb));
sqlCommand.Parameters.Add(AddParameter("@CompanyTNGST", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyTNGST));
sqlCommand.Parameters.Add(AddParameter("@CompanyCST", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyCST));
sqlCommand.Parameters.Add(AddParameter("@CompanyTIN", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyTIN));
sqlCommand.Parameters.Add(AddParameter("@CompanyIECode", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyIECode));
sqlCommand.Parameters.Add(AddParameter("@CompanyCECode", SsDbType.VarChar, ParameterDirection.Input, addCompanyMaster.CompanyCECode));
sqlCommand.Parameters.Add(AddParameter("@PFLimit", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.PFLimit));
sqlCommand.Parameters.Add(AddParameter("@ESILimit", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.ESILimit));
sqlCommand.Parameters.Add(AddParameter("@PFPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.PFPercent));
sqlCommand.Parameters.Add(AddParameter("@EPFPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.EPFPercent));
sqlCommand.Parameters.Add(AddParameter("@FPFPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.FPFPercent));
sqlCommand.Parameters.Add(AddParameter("@ESIPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.ESIPercent));
sqlCommand.Parameters.Add(AddParameter("@ESIPercent_Employer", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.ESIPercent_Employer));
sqlCommand.Parameters.Add(AddParameter("@EDPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.EDPercent));
sqlCommand.Parameters.Add(AddParameter("@Cess1Percent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.Cess1Percent));
sqlCommand.Parameters.Add(AddParameter("@Cess2Percent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.Cess2Percent));
sqlCommand.Parameters.Add(AddParameter("@VatPercent", SsDbType.Int, ParameterDirection.Input, addCompanyMaster.VatPercent));
sqlCommand.Parameters.Add(AddParameter("@CreatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, addCompanyMaster.CreatedBy));
sqlCommand.Parameters.Add(AddParameter("@CreatedDateTime", SsDbType.DateTime, ParameterDirection.Input, addCompanyMaster.CreatedDateTime));
sqlCommand.ExecuteNonQuery();
}
}
public AddCompanyMasterResponseDto AddCompanyMaster(AddCompanyMasterRequestDto request)
{
var registerUserResponseDto = new RegisterUserResponseDto();
var cModel = new AddCompanyMasterCommandModel
{
//Cess1Percent = request.Cess1Percent,
//Cess2Percent = request.Cess2Percent,
//CompanyAddress1 = request.CompanyAddress1,
//CompanyAddress2 = request.CompanyAddress2,
//CompanyCECode = request.CompanyCECode,
//CompanyCity = request.CompanyCity,
//CompanyCode = request.CompanyCode,
//CompanyCST = request.CompanyCST,
//CompanyEmail = request.CompanyEmail,
//CompanyFax = request.CompanyFax,
//CompanyIECode = request.CompanyIECode,
//CompanyName = request.CompanyName,
//CompanyPhone = request.CompanyPhone,
//CompanyPincode = request.CompanyPincode,
//CompanyTIN = request.CompanyTIN,
//CompanyTNGST = request.CompanyTNGST,
//CompanyWeb = request.CompanyWeb,
//CreatedBy = request.CreatedBy,
//CreatedDateTime = request.CreatedDateTime,
//EDPercent = request.EDPercent,
//EPFPercent = request.EPFPercent,
//ESILimit = request.ESILimit,
//ESIPercent = request.ESIPercent,
//ESIPercent_Employer = request.ESIPercent_Employer,
//FPFPercent = request.FPFPercent,
//PFLimit = request.PFLimit,
//PFPercent = request.PFPercent,
//VatPercent = request.VatPercent
};
var response = companyMastersRepository.AddCompanyMaster(cModel);
return(new AddCompanyMasterResponseDto());
}
