public static int Insert_insurance_comprehensive(string str_title) { try { using (Insurance_comprehensive_dsTableAdapters.QueriesTableAdapter adapter = new Insurance_comprehensive_dsTableAdapters.QueriesTableAdapter()) { return(int.Parse(adapter.sp_insert_insurance_comprehensive(str_title, Program.System_user.UserID).ToString())); } } catch (System.Data.SqlClient.SqlException e) { Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, e.Message); } return(0); }
/// <summary> /// /// </summary> /// <param name="str_title"></param> /// <param name="int_exclude_ins_com"></param> /// <returns>true if title available; false otherwise</returns> public static bool Check_ins_com_title_available(string str_title, int int_exclude_ins_com) { try { using (Insurance_comprehensive_dsTableAdapters.QueriesTableAdapter adapter = new Insurance_comprehensive_dsTableAdapters.QueriesTableAdapter()) { return((int)adapter.sp_check_ins_com_title_available(str_title, int_exclude_ins_com) == 0); } } catch (System.Data.SqlClient.SqlException e) { Classes.Class_misc.Display_dataset_error(MethodBase.GetCurrentMethod().DeclaringType.ToString(), MethodBase.GetCurrentMethod().Name, e.Message); } return(false); }