public object AddEbulletin(AddEbulletin addebulltn)
{
dynamic TBAddEbulletinResult;
int str = 0;
try
{
string Result = Ebulletin.createEbulletin(addebulltn);
if (!string.IsNullOrEmpty(Result))
{
str = GlobalFuns.uploadDocs(addebulltn.grpID, Result, "ebulletin");
}
if (str == 0)
{
TBAddEbulletinResult = new { status = "0", message = "success" };
if (addebulltn.ebulletinID != "0")
{
string url = ConfigurationManager.AppSettings["imgPath"] + "php/EditEbulletin.php?newsID=" + addebulltn.ebulletinID;
GroupMaster.Send(url);
}
}
else
{
TBAddEbulletinResult = new { status = "1", message = "failed" }
};
}
catch
{
TBAddEbulletinResult = new { status = "1", message = "failed" };
}
return(new { TBAddEbulletinResult });
}
public static string createEbulletin(AddEbulletin ebulletin)
{
string subgrpIDs = "";
try
{
if (ebulletin.isSubGrpAdmin == "1" && ebulletin.ebulletinType == "0")
{
subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(ebulletin.grpID, ebulletin.memID);
}
MySqlParameter[] param = new MySqlParameter[14];
param[0] = new MySqlParameter("?bulletinID", string.IsNullOrEmpty(ebulletin.ebulletinID) ? "0" : ebulletin.ebulletinID);
param[1] = new MySqlParameter("?bulletinType", string.IsNullOrEmpty(ebulletin.ebulletinType) ? "0" : ebulletin.ebulletinType);
param[2] = new MySqlParameter("?ebulletinTitle", ebulletin.ebulletinTitle);
param[3] = new MySqlParameter("?ebulletinlink", string.IsNullOrEmpty(ebulletin.ebulletinlink) ? "" : ebulletin.ebulletinlink);
param[4] = new MySqlParameter("?ebulletinfile", string.IsNullOrEmpty(ebulletin.ebulletinfileid) ? "" : ebulletin.ebulletinfileid);
param[5] = new MySqlParameter("?memID", ebulletin.memID);
param[6] = new MySqlParameter("?grpID", ebulletin.grpID);
param[7] = new MySqlParameter("?memprofileIDs", string.IsNullOrEmpty(ebulletin.inputIDs) ? "" : ebulletin.inputIDs);
param[8] = new MySqlParameter("?publishDate", ebulletin.publishDate);
param[9] = new MySqlParameter("?expiryDate", ebulletin.expiryDate);
param[10] = new MySqlParameter("?sendSMSAll", string.IsNullOrEmpty(ebulletin.sendSMSAll) ? "0" : ebulletin.sendSMSAll);
param[11] = new MySqlParameter("?sendSMSNonSmartPh", string.IsNullOrEmpty(ebulletin.sendSMSNonSmartPh) ? "0" : ebulletin.sendSMSNonSmartPh);
param[12] = new MySqlParameter("?IsSubGrpAdmin", string.IsNullOrEmpty(ebulletin.isSubGrpAdmin) ? "0" : ebulletin.isSubGrpAdmin);
param[13] = new MySqlParameter("?subgrpIDs", subgrpIDs);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <string>("CALL V5_USPAddEbulletin(?bulletinID,?bulletinType,?ebulletinTitle,?ebulletinlink,?ebulletinfile,?memID,?grpID,?memprofileIDs,?publishDate,?expiryDate,?sendSMSAll,?sendSMSNonSmartPh,?IsSubGrpAdmin,?subgrpIDs)", param).SingleOrDefault();
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
