/// <summary>
/// Delete
/// </summary>
/// <param name="id">string</param>
public void Delete(string id, string userUpdate)
{
if (id != null)
{
// Get current group in dbContext
Interview objDb = GetById(id);
if (objDb != null)
{
//Delete e form
EformDao eDao = new EformDao();
eDao.DeleteEform(objDb.InterviewFormId, objDb.CandidateId.ToString(), (int)Constants.PersonType.Candidate, (int)objDb.Round,userUpdate);
// Set delete info
objDb.DeleteFlag = true;
objDb.UpdatedDate = DateTime.Now;
objDb.UpdatedBy = userUpdate;
new InterviewLogDao().WriteLogForInterview(null, objDb, ELogAction.Delete);
// Submit changes to dbContext
dbContext.Interviews.DeleteOnSubmit(objDb);
dbContext.SubmitChanges();
}
}
}
/// <summary>
/// Insert colection control id and value on form into database,if not exits then addnew else then update
/// Rule to define ControlID is:
/// 1.If control is Checkbox then start with "CheckBox" letter and after is number(ex:CheckBox1).
/// 2.If control is Textbox then start with "TextBox" letter and after is number(ex:TextBox1).
/// ....
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public Message SaveControlToDB(FormCollection form, bool isInsert)
{
Message msg = null;
List<EForm_Detail> detailList = new List<EForm_Detail>();
string EformID = form.Get("Hidden1");
for (int i = 0; i < form.Count; i++)
{
string controlID = form.GetKey(i);
bool flag = false;
foreach (String str in control)
{
if (controlID.StartsWith(str))
{
flag = true;
break;
}
}
if (flag)
{
CRM.Models.EForm_Detail detailItem = new Models.EForm_Detail();
string value = form.Get(controlID);
if (controlID.StartsWith("CheckBox"))
{
value = value.Split(Convert.ToChar(","))[0];
}
detailItem.ControlID = controlID;
detailItem.Value = value;
detailItem.EFormID = Int32.Parse(EformID);
detailList.Add(detailItem);
}
}
CRM.Models.EformDao efDao = new EformDao();
msg = isInsert == true ? efDao.Inser(detailList) : efDao.Update(detailList);
return msg;
}
public Message Update(PerformanceReview pr, string eformMasterId)
{
Message msg = null;
EmployeeDao empDao = new EmployeeDao();
EformDao eformDao = new EformDao();
DbTransaction trans = null;
try
{
if (dbContext.Connection.State == System.Data.ConnectionState.Closed)
{
dbContext.Connection.Open();
}
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
EForm oldEform = null;
PerformanceReview prDB = GetById(pr.ID);
//Update eform
EForm eform = new EForm();
if (!pr.EForm.MasterID.Equals(eformMasterId))
{
//Delete old eform
oldEform = pr.EForm;
//Insert new eform
eform.MasterID = eformMasterId;
eform.PersonID = pr.EmployeeID;
eform.PersonType = (int)Constants.PersonType.Employee;
eform.FormIndex = 1;
eform.CreateDate = DateTime.Now;
eform.CreatedBy = pr.CreatedBy;
dbContext.EForms.InsertOnSubmit(eform);
dbContext.SubmitChanges();
pr.EForm = eform;
}
//Update performance Review
prDB.AssignID = pr.AssignID;
prDB.EForm = pr.EForm;
prDB.AssignRole = pr.AssignRole;
prDB.CCEmail = pr.CCEmail;
prDB.InvolveDate = pr.InvolveDate;
prDB.InvolveID = pr.InvolveID;
prDB.InvolveResolution = pr.InvolveResolution;
prDB.InvolveRole = pr.InvolveRole;
prDB.NextReviewDate = pr.NextReviewDate;
prDB.PRDate = pr.PRDate;
prDB.UpdateDate = DateTime.Now;
prDB.UpdatedBy = pr.UpdatedBy;
prDB.WFResolutionID = pr.WFResolutionID;
if(oldEform!=null)
dbContext.EForms.DeleteOnSubmit(oldEform);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info,
"Performance Review \"" + pr.ID + "\"", "updated");
trans.Commit();
}
catch
{
trans.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Insert performance review
/// </summary>
/// <param name="pr">PerformanceReview</param>
/// <param name="eformMasterId">string</param>
/// <returns>Message</returns>
public Message Insert(PerformanceReview pr, string eformMasterId)
{
Message msg = null;
EmployeeDao empDao = new EmployeeDao();
EformDao eformDao = new EformDao();
DbTransaction trans = null;
try
{
if (dbContext.Connection.State == System.Data.ConnectionState.Closed)
{
dbContext.Connection.Open();
}
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
EForm eform = new EForm();
eform.MasterID = eformMasterId;
eform.PersonID = pr.EmployeeID;
eform.PersonType = (int)Constants.PersonType.Employee;
eform.FormIndex = 1;
eform.CreateDate = DateTime.Now;
eform.CreatedBy = pr.CreatedBy;
dbContext.EForms.InsertOnSubmit(eform);
dbContext.SubmitChanges();
pr.ID = GetNewPrId(pr.EmployeeID);
pr.EFormID = eform.ID;
dbContext.PerformanceReviews.InsertOnSubmit(pr);
msg = new Message(MessageConstants.I0001, MessageType.Info, "PR", "setup");
dbContext.SubmitChanges();
trans.Commit();
}
catch
{
trans.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}