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;
}
}
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);
var Result = _DbTouchbase.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;
}
}
public object GroupSetting(GrpSettingResult grp)
{
dynamic TBGroupSettingResult;
try
{
int Result = Setting.updateGroupSetting(grp);
if (Result > 0)
{
TBGroupSettingResult = new { status = "0", message = "success" };
}
else
{
TBGroupSettingResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBGroupSettingResult = new { status = "1", message = "failed" };
}
return(new { TBGroupSettingResult });
}
