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