public String AddModifyUserMasterData(ClsUserMasterData ObjUserMasterData) { using (ClsMasterManagement_DAL obj = new ClsMasterManagement_DAL()) { return(obj.AddModifyUserMasterData(ObjUserMasterData)); } }
public string AddModifyUserMasterData(ClsUserMasterData ObjUserMasterData) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_UserMaster_ID", ObjUserMasterData.Ref_UserMaster_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Ref_UserMasterData_ID", ObjUserMasterData.Ref_UserMasterData_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@MasterDataName", ObjUserMasterData.UserMasterData, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Description", ObjUserMasterData.Description, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@MandatoryMasterIDs", ObjUserMasterData.MandatoryMasterIDs, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@NonMandatoryMasterIDs", ObjUserMasterData.NonMandatoryMasterIDs, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@AddedBy", ObjUserMasterData.AddedBy, DbType.String); ObJParameterCOl.Add(objDBParameter); string Massage = ""; DBHelper objDbHelper = new DBHelper(); Massage = Convert.ToString(objDbHelper.ExecuteScalar(Constant.AddModifyUserMasterData, ObJParameterCOl, CommandType.StoredProcedure)); return(Massage); } catch (Exception ex) { throw ex; } }