public List <MOMTransaction> GetMOM(int clientId) { List <MOMTransaction> mOMTransactions = new List <MOMTransaction>(); try { Logger.LogInfo("Get: MOM details information process start"); DataTable dtMOM = DataBase.DBService.ExecuteCommand(string.Format(SELECT_MOM_BY_CLIENT_ID, clientId)); DataTable dtMOMPoints = DataBase.DBService.ExecuteCommand(string.Format(SELECT_MOMPOINT_BY_CLIENT_ID, clientId)); foreach (DataRow dr in dtMOM.Rows) { MOMTransaction mOMTransaction = convertToMOMObject(dr, dtMOMPoints); mOMTransactions.Add(mOMTransaction); } Logger.LogInfo("Get: MOM details information process completed."); return(mOMTransactions); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
private MOMTransaction convertToMOMObject(DataRow dr, DataTable dtMOMPoints) { MOMTransaction mOMTransaction = new MOMTransaction(); mOMTransaction.MId = int.Parse(dr["MId"].ToString()); mOMTransaction.MeetingDate = DateTime.Parse(dr["MeetingDate"].ToString()); mOMTransaction.MeetingType = dr.Field <string>("MeetingType"); mOMTransaction.CId = int.Parse(dr["ClientId"].ToString()); mOMTransaction.MarkAsImportant = bool.Parse(dr["MarkAsImportant"].ToString()); mOMTransaction.Duration = dr.Field <string>("Duration"); mOMTransaction.Notes = dr.Field <string>("Notes"); mOMTransaction.MOMPoints = new List <MOMPoint>(); foreach (DataRow drMOMPoint in dtMOMPoints.Select("MId = " + mOMTransaction.MId)) { MOMPoint mOMPoint = new MOMPoint(); mOMPoint.DiscussedPoint = drMOMPoint.Field <string>("DiscussedPoint"); mOMPoint.EmpId = drMOMPoint["EmpId"] == DBNull.Value ? 0 : int.Parse(drMOMPoint["EmpId"].ToString()); mOMPoint.Id = int.Parse(drMOMPoint["Id"].ToString()); mOMPoint.MId = int.Parse(drMOMPoint["MId"].ToString()); mOMPoint.FutureAction = drMOMPoint.Field <string>("FutureActionPlan"); mOMPoint.Responsibility = drMOMPoint.Field <string>("Responsibility"); mOMPoint.TaskId = drMOMPoint["TaskId"] == DBNull.Value ? "" : drMOMPoint.Field <string>("TaskId"); mOMPoint.TaskStatus = drMOMPoint.Field <string>("TaskStatus"); mOMPoint.UserName = drMOMPoint.Field <string>("UserName"); mOMTransaction.MOMPoints.Add(mOMPoint); } return(mOMTransaction); }
public void Update(MOMTransaction mOMTransaction) { try { string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, mOMTransaction.CId)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_MOM, mOMTransaction.MeetingDate.ToString("yyyy-MM-dd"), mOMTransaction.MeetingType, mOMTransaction.CId, (mOMTransaction.MarkAsImportant == true) ? 1 : 0, mOMTransaction.Duration, mOMTransaction.Notes, mOMTransaction.MId), true); foreach (MOMPoint point in mOMTransaction.MOMPoints) { if (point.Id == 0) { DataBase.DBService.ExecuteCommandString(string.Format(INSERT_MOM_POINTS, mOMTransaction.MId, point.DiscussedPoint, point.Responsibility, point.EmpId, point.TaskId, point.TaskStatus, point.FutureAction), true); } else { DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_MOM_POINTS, point.DiscussedPoint, point.Responsibility, point.EmpId, point.TaskId, point.TaskStatus, point.Id, point.FutureAction), true); } } DataBase.DBService.CommitTransaction(); //return mid; } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }
private int getMOMId(MOMTransaction mOMTransaction) { return(int.Parse(DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_MOM_BY_MOMINFORAMTION, mOMTransaction.MeetingDate.ToString("yyyy-MM-dd hh:mm:ss"), mOMTransaction.MeetingType, mOMTransaction.CId, (mOMTransaction.MarkAsImportant == true) ? 1 : 0, mOMTransaction.Duration, mOMTransaction.Notes )))); }
public Result Update(MOMTransaction mOMTransaction) { var result = new Result(); try { MOMService momService = new MOMService(); momService.Update(mOMTransaction); result.IsSuccess = true; } catch (Exception exception) { result.IsSuccess = false; result.ExceptionInfo = exception; } return(result); }
public Result Add(MOMTransaction mOMTransaction) { var result = new Result <int>(); try { MOMService momService = new MOMService(); result.Value = momService.Add(mOMTransaction); result.IsSuccess = true; } catch (Exception exception) { result.IsSuccess = false; result.ExceptionInfo = exception; } return(result); }