public static int updateGroupSetting(GrpSettingResult grp)
{
try
{
var GroupId = new MySqlParameter("?GrpId", grp.GroupId);
var ModuleId = new MySqlParameter("?ModuleId", grp.ModuleId);
var GroupProfileId = new MySqlParameter("?profileId", grp.GroupProfileId);
var UpdatedValue = new MySqlParameter("?UpdatedValue", grp.UpdatedValue);
var mobileSelf = new MySqlParameter("?showMobileSeflfClub", grp.showMobileSeflfClub);
var mobileOutside = new MySqlParameter("?showMobileOutsideClub", grp.showMobileOutsideClub);
var emailSelf = new MySqlParameter("?showEmailSeflfClub", grp.showEmailSeflfClub);
var emailOutside = new MySqlParameter("?showEmailOutsideClub", grp.showEmailOutsideClub);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL USPGroupSettings(?GrpId,?ModuleId,?profileId,?UpdatedValue,?showMobileSeflfClub,?showMobileOutsideClub,?showEmailSeflfClub,?showEmailOutsideClub)",
GroupId, ModuleId, GroupProfileId, UpdatedValue, mobileSelf, mobileOutside, emailSelf, emailOutside);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
//private static TouchBaseWebAPI.Data.row_productionEntities _DBTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();
public static int createTicket(SendTicket tkt)
{
try
{
var grpID = new MySqlParameter("?groupId", tkt.groupId);
var profileId = new MySqlParameter("?memberProfileId", tkt.memberProfileId);
var smsText = new MySqlParameter("?smsText", tkt.smsText);
var createBy = new MySqlParameter("?createBy", tkt.createBy);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL V2_USPAddTicket(?groupId,?memberProfileId,?smsText,?createBy)",
grpID, profileId, smsText, createBy);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
GC.Collect();
}
}
public static int updateTouchbaseSetting(GroupDetail grp)
{
try
{
var grpId = new MySqlParameter("?grpId", grp.GroupId);
var updateValue = new MySqlParameter("?updateValue", grp.UpdatedValue);
var mainMstId = new MySqlParameter("?mainMstId", grp.mainMasterId);
var Result = _DbTouchbase.ExecuteStoreCommand("CALL USPtouchbase_rowSettings(?grpId,?updateValue,?mainMstId)", grpId, updateValue, mainMstId);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetEbulletinDetails(EbulletinDetails ebull)
{
try
{
var EbullID = new MySqlParameter("?EbullID", ebull.ebulletinID);
var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);
var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateDocumentDetails(UpdateReadFlag doc)
{
try
{
var docID = new MySqlParameter("?docID", doc.docID);
var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);
var Result = _DBTouchbase.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetEbulletinDetails(EbulletinDetails ebull)
{
try
{
var EbullID = new MySqlParameter("?EbullID", ebull.ebulletinID);
var memberProfileID = new MySqlParameter("?memberProfileID", ebull.memberProfileID);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL USPGetEbulletinDetails(?EbullID,?memberProfileID)", EbullID, memberProfileID);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int UpdateDocumentDetails(UpdateReadFlag doc)
{
try
{
var docID = new MySqlParameter("?docID", doc.docID);
var memberProfileID = new MySqlParameter("?memberProfileID", doc.memberProfileID);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL USPUpdateDocumentDetails(?docID,?memberProfileID)", docID, memberProfileID);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
//private static TouchBaseWebAPI.Data.row_productionEntities _DbTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();
public static int updateTouchbaseSetting(GroupDetail grp)
{
try
{
var grpId = new MySqlParameter("?grpId", grp.GroupId);
var updateValue = new MySqlParameter("?updateValue", grp.UpdatedValue);
var mainMstId = new MySqlParameter("?mainMstId", grp.mainMasterId);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreCommand("CALL USPtouchbase_rowSettings(?grpId,?updateValue,?mainMstId)", grpId, updateValue, mainMstId);
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int createTicket(SendTicket tkt)
{
try
{
var grpID = new MySqlParameter("?groupId", tkt.groupId);
var profileId = new MySqlParameter("?memberProfileId", tkt.memberProfileId);
var smsText = new MySqlParameter("?smsText", tkt.smsText);
var createBy = new MySqlParameter("?createBy", tkt.createBy);
var Result = _DBTouchbase.ExecuteStoreCommand("CALL V2_USPAddTicket(?groupId,?memberProfileId,?smsText,?createBy)",
grpID, profileId, smsText, createBy);
return(Result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GC.Collect();
}
}