public CommissionAgent InsertCommissionAgent(CommissionAgent model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction trn = connection.BeginTransaction();
string sql = @"INSERT INTO CommissionAgent (CommissionAgentRefNo,CommissionAgentName,Address1,Address2,Address3,Phone,CreatedBy,CreatedDate,OrganizationId)
VALUES(@CommissionAgentRefNo,@CommissionAgentName,@Address1,@Address2,@Address3,@Phone,@CreatedBy,getDate(),@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
int id = 0;
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(CommissionAgent).Name, "0", 1);
model.CommissionAgentRefNo = "CA/" + internalid;
id = connection.Query <int>(sql, model, trn).Single();
model.CommissionAgentId = id;
trn.Commit();
}
catch (Exception e)
{
trn.Rollback();
model.CommissionAgentId = 0;
model.CommissionAgentRefNo = null;
}
return(model);
}
}
public ActionResult Edit(CommissionAgent model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
var repo = new CommissionAgentRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "CommissionAgent", "CommissionAgentName", model.CommissionAgentName, "CommissionAgentId", model.CommissionAgentId);
if (!isexists)
{
var result = new CommissionAgentRepository().UpdateCommissionAgent(model);
if (result.CommissionAgentId > 0)
{
TempData["Success"] = "Updated Successfully!";
TempData["RefNo"] = result.CommissionAgentRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["RefNo"] = null;
return(View("Create", model));
}
}
else
{
TempData["error"] = "This Name Alredy Exists!!";
TempData["RefNo"] = null;
return(View("Create", model));
}
}
public ActionResult Create(CommissionAgent model)
{
var repo = new CommissionAgentRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "CommissionAgent", "CommissionAgentName", model.CommissionAgentName, null, null);
if (!isexists)
{
model.OrganizationId = OrganizationId;
var result = new CommissionAgentRepository().InsertCommissionAgent(model);
if (result.CommissionAgentId > 0)
{
TempData["Success"] = "Added Successfully!";
TempData["RefNo"] = result.CommissionAgentRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["RefNo"] = null;
return(View("Create", model));
}
}
else
{
TempData["error"] = "This Name Alredy Exists!!";
TempData["RefNo"] = null;
return(View("Create", model));
}
}
public List <Guid> ExecuteTask(IOrder order)
{
var result = new List <Guid>();
var activity = new PackagingSlip();
var activity2 = new CommissionAgent();
result.Add(activity2.ProcessActivity(order));
result.Add(activity.ProcessActivity(order));
return(result);
}
public CommissionAgent DeleteCommissionAgent(CommissionAgent model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"UPDATE CommissionAgent SET isActive = 0 OUTPUT INSERTED.CommissionAgentId WHERE CommissionAgentId = @CommissionAgentId";
try
{
var id = connection.Execute(sql, model);
model.CommissionAgentId = id;
}
catch (Exception ex)
{
model.CommissionAgentId = 0;
}
return(model);
}
}
public ActionResult Delete(CommissionAgent model)
{
var result = new CommissionAgentRepository().DeleteCommissionAgent(model);
if (result.CommissionAgentId > 0)
{
TempData["Success"] = "Deleted Successfully!";
TempData["RefNo"] = model.CommissionAgentRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["RefNo"] = null;
return(View("Create", model));
}
}
public CommissionAgent UpdateCommissionAgent(CommissionAgent model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"UPDATE CommissionAgent SET CommissionAgentName = @CommissionAgentName,Address1 = @Address1 ,Address2 = @Address2,Address3 = @Address3,
Phone = @Phone, CreatedBy = @CreatedBy,CreatedDate= GETDATE(),OrganizationId = @OrganizationId OUTPUT INSERTED.CommissionAgentId
WHERE CommissionAgentId = @CommissionAgentId";
try
{
var id = connection.Execute(sql, model);
model.CommissionAgentId = id;
}
catch (Exception ex)
{
model.CommissionAgentId = 0;
}
return(model);
}
}
public async Task Should_Load_ACommissionAgent()
{
CommissionAgent agent = new CommissionAgent(_sqlExecutor);
Assert.NotNull(agent);
IDictionary <string, string> fields = new Dictionary <string, string>();
string numComi = "0000002";
fields.Add(CommissionAgent.Comisio, "NUM_COMI, PERSONA, NIF, TIPOCOMI, " +
"VENDE_COMI, MERCADO, NEGOCIO, CANAL, CLAVEPPTO, " +
"ORIGEN_COMI, ZONAOFI, direccion, cp, poblacion, " +
"provincia, nacioper, telefono, fax, " +
"Movil, alta_comi, baja_comi, idioma, IATA, IVASINO, " +
"RETENSINO, NACIONAL, CONCEPTOS_COND, AGENCIA, TRADUCE_WS, " +
"TRUCK_RENTAL_BROKER, COMBUS_PREPAGO_COMI, NO_GENERAR_AUTOFAC, " +
"TODOS_EXTRAS, AUTO_ONEWAY, COT_INCLUIDOS_SIN_GRUPO, " +
"NO_MAIL_RES, AUTOFAC_SIN_IVA, " +
"COMISION_SIN_IVA_COM");
bool isLoaded = await agent.LoadValue(fields, numComi);
Assert.True(isLoaded);
}
