public DataSet InsertRemoveActions(Int64 UserId, AddNotificationAction obj)
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = Procedures.AddUpdateNotificationAction;
sqlCommand.Parameters.AddWithValue("@UserId", UserId);
sqlCommand.Parameters.AddWithValue("@NotificationId", obj.NotificationId);
sqlCommand.Parameters.AddWithValue("@MeetingDate", obj.Meetingdate);
sqlCommand.Parameters.AddWithValue("@NotificationActions", obj.ActionXML);
sqlCommand.Parameters.AddWithValue("@MeetingNote", obj.MeetingNote);
sqlCommand.Parameters.AddWithValue("@NotificationGroup", obj.NotificationGroup);
sqlCommand.Parameters.AddWithValue("@MeetingId", obj.MeetingId);
return(DAL.GetDataSet(ConfigurationHelper.connectionString, sqlCommand));
}
}
public EditNotificationMeeting InsertRemoveActions(Int64 UserId, AddNotificationAction objAdd)
{
EditNotificationMeeting objE = new EditNotificationMeeting();
MOMDataManager objDM = new MOMDataManager();
DataSet ds = objDM.InsertRemoveActions(UserId, objAdd);
if (ds != null)
{
int tblIndex = -1;
tblIndex++;
if (ds.Tables.Count > 0 && ds.Tables[tblIndex].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[tblIndex].Rows)
{
objE.NotificationNumber = Convert.ToString(dr["NotificationNumber"]);
objE.Title = Convert.ToString(dr["Title"]);
objE.Status = Convert.ToString(dr["Stage"]);
objE.MeetingNote = Convert.ToString(dr["MeetingNote"]);
objE.MeetingDate = Convert.ToString(dr["MeetingDate"]);
objE.RetainedForNextDiscussion = Convert.ToBoolean(dr["RetainedForNextDiscussion"]);
}
}
tblIndex++;
if (ds.Tables.Count > 0 && ds.Tables[tblIndex].Rows.Count > 0)
{
List <EditAction> ActionList = new List <EditAction>();
foreach (DataRow dr in ds.Tables[tblIndex].Rows)
{
EditAction objNotificationAction = new EditAction();
objNotificationAction.NotificationActionId = Convert.ToInt64(dr["NotificationActionId"]);
objNotificationAction.ActionId = Convert.ToInt32(dr["ActionId"]);
objNotificationAction.ActionName = Convert.ToString(dr["Action"]);
objNotificationAction.RequiredOn = Convert.ToString(dr["RequiredOn"]);
objNotificationAction.MailId = Convert.ToInt64(dr["MailId"]);
objNotificationAction.UpdatedOn = Convert.ToString(dr["UpdatedOn"]);
ActionList.Add(objNotificationAction);
}
objE.Actions = ActionList;
}
}
return(objE);
}
public IHttpActionResult AddUpdateNotificationAction(Int64 Id, AddNotificationAction obj)
{
MomBusinessService objAM = new MomBusinessService();
return(Ok(objAM.InsertRemoveActions(Id, obj)));
}
