public JobCardTaskMaster InsertTask(JobCardTaskMaster objTask)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
var result = new JobCardTaskMaster();
IDbTransaction trn = connection.BeginTransaction();
string sql = @"INSERT INTO JobCardTaskMaster(JobCardTaskRefNo,JobCardTaskName,MinimumRate,ActualHrs,CreatedBy,CreatedDate,OrganizationId)
VALUES(@JobCardTaskRefNo,@JobCardTaskName,@MinimumRate,@ActualHrs,@CreatedBy,@CreatedDate,@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(JobCardTaskMaster).Name, "0", 1);
objTask.JobCardTaskRefNo = "T/" + internalid;
int id = connection.Query <int>(sql, objTask, trn).Single();
objTask.JobCardTaskMasterId = id;
InsertLoginHistory(dataConnection, objTask.CreatedBy, "Create", "Task", id.ToString(), "0");
//connection.Dispose();
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
objTask.JobCardTaskMasterId = 0;
objTask.JobCardTaskRefNo = null;
}
return(objTask);
}
}
public int DeleteTask(JobCardTaskMaster objTask)
{
int result = 0;
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @" Update JobCardTaskMaster Set isActive=0 WHERE JobCardTaskMasterId=@JobCardTaskMasterId";
try
{
var id = connection.Execute(sql, objTask);
objTask.JobCardTaskMasterId = id;
InsertLoginHistory(dataConnection, objTask.CreatedBy, "Delete", "Task", id.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(JobCardTaskMaster model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
var repo = new TaskRepository();
bool isexists = repo.IsFieldExists(repo.ConnectionString(), "JobCardTaskMaster", "JobCardTaskName", model.JobCardTaskName, "JobCardTaskMasterId", model.JobCardTaskMasterId);
if (!isexists)
{
var result = new TaskRepository().UpdateTask(model);
if (result.JobCardTaskMasterId > 0)
{
TempData["Success"] = "Updated Successfully!";
TempData["JobCardTaskRefNo"] = result.JobCardTaskRefNo;
return(RedirectToAction("Create"));
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["JobCardTaskRefNo"] = null;
return(View("Create", model));
}
}
else
{
TempData["error"] = "This Name Alredy Exists!!";
TempData["JobCardTaskRefNo"] = null;
return(View("Create", model));
}
}
public ActionResult Delete(JobCardTaskMaster model)
{
int result = new TaskRepository().DeleteTask(model);
if (result == 0)
{
TempData["Success"] = "Deleted Successfully!";
TempData["JobCardTaskRefNo"] = model.JobCardTaskRefNo;
return(RedirectToAction("Create"));
}
else
{
if (result == 1)
{
TempData["error"] = "Sorry!! You Cannot Delete This Task. It Is Already In Use";
TempData["JobCardTaskRefNo"] = null;
}
else
{
TempData["error"] = "Oops!!..Something Went Wrong!!";
TempData["JobCardTaskRefNo"] = null;
}
return(RedirectToAction("Create"));
}
}
public ActionResult Create()
{
ViewBag.Title = "Create";
JobCardTaskMaster JobCardTaskMaster = new JobCardTaskMaster();
JobCardTaskMaster.JobCardTaskRefNo = new TaskRepository().GetRefNo(JobCardTaskMaster);
return(View(JobCardTaskMaster));
}
public int UpdateJobCardTaskMaster(JobCardTaskMaster objJobCardTaskMaster)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"UPDATE JobCardTaskMaster SET JobCardTaskName = @JobCardTaskName ,CreatedBy = @CreatedBy ,CreatedDate = @CreatedDate OUTPUT INSERTED.JobCardTaskMasterId WHERE JobCardTaskMasterId = @JobCardTaskMasterId";
var id = connection.Execute(sql, objJobCardTaskMaster);
InsertLoginHistory(dataConnection, objJobCardTaskMaster.CreatedBy, "Update", "Job Card Task Master", id.ToString(), "0");
return(id);
}
}
public int InsertJobCardTaskMaster(JobCardTaskMaster objJobCardTaskMaster)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"insert into JobCardTaskMaster(JobCardTaskName,CreatedBy,CreatedDate,OrganizationId) Values (@JobCardTaskName,@CreatedBy,@CreatedDate,@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
var id = connection.Query <int>(sql, objJobCardTaskMaster).Single();
InsertLoginHistory(dataConnection, objJobCardTaskMaster.CreatedBy, "Create", "Job Card Task Master", id.ToString(), "0");
return(id);
}
}
public JobCardTaskMaster UpdateTask(JobCardTaskMaster objTask)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string sql = @"Update JobCardTaskMaster Set JobCardTaskRefNo=@JobCardTaskRefNo,
JobCardTaskName=@JobCardTaskName,MinimumRate=@MinimumRate,ActualHrs=@ActualHrs
OUTPUT INSERTED.JobCardTaskMasterId WHERE JobCardTaskMasterId=@JobCardTaskMasterId";
var id = connection.Execute(sql, objTask);
InsertLoginHistory(dataConnection, objTask.CreatedBy, "Update", "Task", id.ToString(), "0");
return(objTask);
}
}
public string GetRefNo(JobCardTaskMaster objTask)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
string RefNo = "";
var result = new JobCardTaskMaster();
IDbTransaction trn = connection.BeginTransaction();
try
{
int internalid = DatabaseCommonRepository.GetInternalIDFromDatabase(connection, trn, typeof(JobCardTaskMaster).Name, "0", 0);
RefNo = "T/" + internalid;
trn.Commit();
}
catch (Exception ex)
{
trn.Rollback();
}
return(RefNo);
}
}
