コード例 #1
0
ファイル: MomBL.cs プロジェクト: sujeetkumar6870/FinalMOM
 public void AddMOMTransaction(MomBO pMomBO, ParticipantsBO[] pParticipantsBO, ActionItemsBO[] pActionItemsBO, AgendaBO[] pAgendaBO)
 {
     try
     {
         MomDA objMomDA = new MomDA();
         objMomDA.AddMOMTransaction(pMomBO, pParticipantsBO, pActionItemsBO, pAgendaBO);
     }
     catch (Exception pEx)
     {
         throw pEx;
     }
 }
コード例 #2
0
        public static string BindMOMTable()
        {
            DataTable dt = new DataTable();

            List <MomBO> MomDetails = new List <MomBO>();

            JavaScriptSerializer js      = new JavaScriptSerializer();
            HttpContext          Context = HttpContext.Current;

            MomBL objMomBL = new MomBL();

            dt = objMomBL.GetMomList();

            foreach (DataRow dtrow in dt.Rows)
            {
                DateTime temp = Convert.ToDateTime(dtrow["Date"]);

                var MomList = new MomBO
                {
                    Id = Convert.ToInt32(dtrow["ID"]),
                    //DateTime temp= dtrow["Date"].Date.ToS

                    tempDate = temp.ToString("MM/dd/yyyy"),

                    Title = dtrow["Title"].ToString(),

                    //Facilitator = Convert.ToInt32(dtrow["Facilitator"]),

                    tempFacilitator = dtrow["tempFacilitator"].ToString(),

                    //Recorder = Convert.ToInt32(dtrow["Recorder"]),

                    tempRecorder = dtrow["tempRecorder"].ToString(),

                    LocationDetails = dtrow["LocationDetails"].ToString()
                };

                MomDetails.Add(MomList);
            }

            string JsonData = js.Serialize(MomDetails);

            return(JsonData);
        }
コード例 #3
0
 public static void AddMOMTransaction(MomBO MomBO, ParticipantsBO[] ParticipantsBO, ActionItemsBO[] ActionItemsBO, AgendaBO[] AgendaBO)
 {
     MomBL objUserBL = new MomBL();
     objUserBL.AddMOMTransaction(MomBO, ParticipantsBO, ActionItemsBO, AgendaBO);
 }
コード例 #4
0
ファイル: MomDA.cs プロジェクト: sujeetkumar6870/FinalMOM
        //MomBO objMomBO, ParticipantsBO objPartBO, AgendaBO objAgendaBO, ActionItemsBO objActionBO
        public void AddMOMTransaction(MomBO pMomBO, ParticipantsBO[] pParticipantsBO, ActionItemsBO[] pActionItemsBO, AgendaBO[] pAgendaBO)
        {
            #region //without transaction and seperate procedure
            DBHelper.ExecuteProcedure("AddMOM", "@Title", pMomBO.Title, "@Date", pMomBO.Date, "@Facilitator", pMomBO.Facilitator, "@Recorder", pMomBO.Recorder, "@LocationDetails", pMomBO.LocationDetails, "@CreatedBy", "Sujeet Kumar", "@CreatedDate", DateTime.Now, "@ModifiedBy", "Sujeet Kumar", "@ModifiedDate", DateTime.Now);

            DataTable dt = DBHelper.ExecuteQuery("select mid from tempMomID where id=1");

            int pNewMomID = Convert.ToInt32(dt.Rows[0][0]);

            foreach (ActionItemsBO item in pActionItemsBO)
            {
                DBHelper.ExecuteProcedure("AddActionItems", "@ActionItem", item.ActionItem, "@Responsible", item.Responsible, "@Status", item.Status, "@DueDate", item.DueDate, "@CloseDate", item.CloseDate, "@MomId", pNewMomID, "@Discussion", item.Discussion);
            }

            foreach (AgendaBO item in pAgendaBO)
            {
                DBHelper.ExecuteProcedure("AddAgenda", "@DiscussionTopic", item.DiscussionTopic, "@Responsible", item.Responsible, "@MomId", pNewMomID, "@Time", item.Time, "@Purpose", item.Purpose, "@Discussion", item.Discussion);
            }

            foreach (ParticipantsBO item in pParticipantsBO) //MomId will be fetched from database and here the sequesce of query executed matters It should be executed just after AddMOM SP
            {
                DBHelper.ExecuteProcedure("AddParticipants", "@UserID", item.UserID, "@MomID", pNewMomID, "@Availability", item.Availability);
            }
            #endregion


            #region //old code with Transaction
            //string connectionString = "Integrated Security =sspi; database=ESupport; server=PACL5XS5AL\\SQLEXPRESS";
            //using (SqlConnection connection = new SqlConnection(connectionString))
            //{
            //    connection.Open();
            //    SqlCommand command = connection.CreateCommand();
            //    SqlTransaction transaction;

            //    transaction = connection.BeginTransaction("MOMTransaction");
            //    command.Connection = connection;
            //    command.Transaction = transaction;

            //    try
            //    {

            //        //command.CommandText = "AddMOM";
            //        //command.CommandType = System.Data.CommandType.StoredProcedure;

            //        //int pNewMomID = Convert.ToInt32(DBHelper.ExecuteScalar(connection,"select SCOPE_IDENTITY()"));
            //        command.CommandText = "select SCOPE_IDENTITY()";
            //        //Int32 pNewMomID = (Int32) command.ExecuteScalar();
            //        //int pNewMomID = Convert.ToInt32(command.ExecuteNonQuery());

            //        foreach (ParticipantsBO item in pParticipantsBO)
            //        {
            //            DBHelper.ExecuteProcedure("AddParticipants",connection, "@UserID", item.UserID, "@MomID", pNewMomID, "@Availability", item.Availability);
            //        }



            //        foreach (ActionItemsBO item in pActionItemsBO)
            //        {
            //            DBHelper.ExecuteProcedure("AddActionItems", connection, "@ActionItem", item.ActionItem, "@Responsible", item.Responsible, "@Status", item.Status, "@DueDate", item.DueDate, "@CloseDate", item.CloseDate, "@MomId", pNewMomID, "@Discussion", item.Discussion);
            //        }
            //        foreach (AgendaBO item in pAgendaBO)
            //        {
            //            DBHelper.ExecuteProcedure("AddAgenda", connection, "@DiscussionTopic", item.DiscussionTopic, "@Responsible", item.Responsible, "@MomId", pNewMomID, "@Time", item.Time, "@Purpose", item.Purpose, "@Discussion", item.Discussion);
            //        }

            //        transaction.Commit();
            //        connection.Close();
            //        //DBHelper.ExecuteProcedure("AddActionItems", "@ActionItem", pParticipantsBO. "@Responsible", "@Status", "@DueDate", "@CloseDate", "@MomId")
            //    }
            //    catch (Exception pEx)
            //    {
            //        connection.Close();
            //        //try
            //        //{
            //        //    transaction.Rollback();
            //        //}
            //        //catch (Exception pEx2)
            //        //{

            //        //    throw pEx2;
            //        //}
            //        throw pEx;
            //    }
            //}
            #endregion
        }