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);
}
