public static bool SetEvent(Event1 oEvent, int iUserId, List <TInt> to) { try { bool isNew; isNew = oEvent.iEventId == 0 ? true : false; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("iEventId", oEvent.iEventId)); parameters.Add(new SqlParameter("nvName", oEvent.nvName)); parameters.Add(new SqlParameter("dtEventDate", oEvent.dtEventDate)); parameters.Add(new SqlParameter("nvPlace", oEvent.nvPlace)); parameters.Add(new SqlParameter("nvComments", oEvent.nvComments)); parameters.Add(new SqlParameter("iUserId", iUserId)); parameters.Add(new SqlParameter("participantIds", ObjectGenerator <TInt> .GetDataTable(to))); if (!isNew) { SqlDataAccess.ExecuteDatasetSP("TEvent_INS/UPD", parameters); } if (isNew) { User user = User.GetUser(iUserId); DataRowCollection drc = SqlDataAccess.ExecuteDatasetSP("TEvent_INS/UPD", parameters).Tables[0].Rows; for (int i = 0; i < drc.Count; i++) { int iPersonId = int.Parse(drc[i]["iPersonId"].ToString()); string nvEmail = drc[i]["nvEmail"].ToString(); string body = "<b>הנך מוזמן ל" + oEvent.nvName + "</b><br>שיתקיים ב" + oEvent.nvPlace + "<br>בתאריך " + oEvent.dtEventDate + "<br>" + oEvent.nvComments + "<br><br> <b> בברכה </b> <br>" + user.nvFirstName + " " + user.nvLastName + "<br> עמותת ונתנו ידידים"; string from = user.nvEmail; if (user.nvEmail == "" || user.nvEmail == null) { from = ConfigSettings.ReadSetting("Email"); } if (SendMessagesHandler.SendEmailOrFax(from, nvEmail, oEvent.nvName, body, null) == true) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("iEventId", drc[i]["iEventId"])); param.Add(new SqlParameter("iPersonId", iPersonId)); param.Add(new SqlParameter("iStatusType", 34)); //סטטוס קיבל הודעה SqlDataAccess.ExecuteDatasetSP("TParticipantsUpdateArrivalStatus_UPD", param); } } //SendMessagesHandler.SendEmailOrFax() } return(true); } catch (Exception ex) { Log.LogError("set event / TEvent_INS/UPD", "ex" + ex); return(false); } }
public static bool AddStudentsToAvrech(List <T2Int> studentAndAvrechArr, int iUserId) { try { List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add(new SqlParameter("iUserId", iUserId)); sqlParameters.Add(new SqlParameter("studentAndAvrechArr", ObjectGenerator <T2Int> .GetDataTable(studentAndAvrechArr))); SqlDataAccess.ExecuteDatasetSP("TAvrechStudents_INS/UPD", sqlParameters); //List<Student> students = ObjectGenerator<Student>.GeneratListFromDataRowCollection(drc); return(true); } catch (Exception ex) { return(false); } }
public static bool DeleteCategoryType(int iUserId, int iCatTypeId) { try { SqlDataAccess.ExecuteDatasetSP("TCategoryType_DEL", new List <SqlParameter>() { new SqlParameter("iUserId", iUserId), new SqlParameter("catTypeIds", ObjectGenerator <int> .GetDataTable("id", new List <int>() { iCatTypeId })) }); return(true); } catch (Exception ex) { Log.LogError("DeleteCategoryType / TCategoryType_DEL", "iUserId = " + iUserId + ", iCatTypeId = " + iCatTypeId + ", exception = " + ex); return(false); } }