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