public CostingParameters InsertCosting(CostingParameters objCosting)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
var result = new CostingParameters();
IDbTransaction trn = connection.BeginTransaction();
string sql = @"INSERT INTO CostingParameters (Description,CostingRefNo,CreatedBy,CreatedDate,OrganizationId,isActive)
VALUES(@Description,@CostingRefNo,@CreatedBy,@CreatedDate,@OrganizationId,1);
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(CostingParameters).Name, "0", 1);
objCosting.CostingRefNo = "cost/" + internalid;
int id = connection.Query <int>(sql, objCosting, trn).Single();
objCosting.CostingId = id;
InsertLoginHistory(dataConnection, objCosting.CreatedBy, "Create", "CostingParameters", internalid.ToString(), "0");
//connection.Dispose();
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
objCosting.CostingId = 0;
objCosting.CostingRefNo = null;
}
return(objCosting);
}
}
public int DeleteCostingParameters(CostingParameters objCosting)
{
int result = 0;
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @" Update CostingParameters Set isActive=0 WHERE CostingId=@CostingId";
try
{
var id = connection.Execute(sql, objCosting);
objCosting.CostingId = id;
InsertLoginHistory(dataConnection, objCosting.CreatedBy, "Delete", "CostingId", objCosting.CostingId.ToString(), "0");
result = 0;
}
catch (SqlException ex)
{
int err = ex.Errors.Count;
if (ex.Errors.Count > 0) // Assume the interesting stuff is in the first error
{
switch (ex.Errors[0].Number)
{
case 547: // Foreign Key violation
result = 1;
break;
default:
result = 2;
break;
}
}
}
return(result);
}
}
public ActionResult Edit(CostingParameters model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
var repo = new CostingParametersRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "CostingParameters", "Description", model.Description, "CostingId", model.CostingId);
if (!isexists)
{
var result = new CostingParametersRepository().UpdateCostingParameters(model);
if (result.CostingId > 0)
{
TempData["Success"] = "Updated Successfully!";
TempData["CostingRefNo"] = result.CostingRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["CostingRefNo"] = null;
return(View("Create", model));
}
}
else
{
TempData["error"] = "This Name Alredy Exists!!";
TempData["CostingRefNo"] = null;
return(View("Create", model));
}
}
public ActionResult Delete(CostingParameters model)
{
int result = new CostingParametersRepository().DeleteCostingParameters(model);
if (result == 0)
{
TempData["Success"] = "Deleted Successfully!";
TempData["CostingRefNo"] = model.CostingRefNo;
return(RedirectToAction("Create"));
}
else
{
if (result == 1)
{
TempData["error"] = "Sorry!! You Cannot Delete Costing parameter It Is Already In Use";
TempData["CostingRefNo"] = null;
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["CostingRefNo"] = null;
}
return(RedirectToAction("Create"));
}
}
public ActionResult Create()
{
ViewBag.Title = "Create";
CostingParameters costing = new CostingParameters();
costing.CostingRefNo = new CostingParametersRepository().GetRefNo(costing);
return(View(costing));
}
public CostingParameters UpdateCostingParameters(CostingParameters objCosting)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Update CostingParameters Set CostingRefNo=@CostingRefNo,Description=@Description OUTPUT INSERTED.CostingId WHERE CostingId=@CostingId";
var id = connection.Execute(sql, objCosting);
InsertLoginHistory(dataConnection, objCosting.CreatedBy, "Update", "CostingParameters", objCosting.CostingId.ToString(), "0");
return(objCosting);
}
}
public string GetRefNo(CostingParameters objCosting)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string RefNo = "";
var result = new CostingParameters();
IDbTransaction trn = connection.BeginTransaction();
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(CostingParameters).Name, "0", 0);
RefNo = "cost/" + internalid;
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
}
return(RefNo);
}
}
