public HttpResponseMessage AddFaculty(DataFaculties data)
{
string EmpName = data.EmpName;
string Email = data.Email;
string MobileNumber = data.MobileNumber;
string EPassword = data.EPassword;
int DesignationID = data.DesignationID;
int DepartmentID = data.DepartmentID;
var db = DbUtils.GetDBConnection();
db.Connection.Open();
using (TransactionScope scope = new TransactionScope())
{
var query = db.Query("Employee").InsertGetId <int>(new
{
EmpName = EmpName,
Email = Email,
MobileNumber = MobileNumber,
EPassword = EPassword,
DesignationID = DesignationID,
DepartmentID = DepartmentID,
RefID = 1
});
scope.Complete(); // if record is entered successfully , transaction will be committed
db.Connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK, query));
}
}
public HttpResponseMessage DeleteFaculty(DataFaculties data)
{
int id = data.EmpID;
var db = DbUtils.GetDBConnection();
db.Connection.Open();
using (TransactionScope scope = new TransactionScope())
{
try
{
db.Query("Employee").Where("EmpID", id).Delete();
scope.Complete();
db.Connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
scope.Dispose();
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
}
