public static int?UserUpdate(User user, int iUserManagerId, int changeEligibility) { try { List <SqlParameter> parameters = ObjectGenerator <User> .GetSqlParametersFromObject(user); parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId)); parameters.Add(new SqlParameter("changeEligibility", changeEligibility)); if (user.lLanguage != null && user.lLanguage.Count != 0) { parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lLanguage, "int", "lLanguage")); } if (user.lOrderType != null && user.lOrderType.Count != 0) { parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lOrderType, "int", "lOrderType")); } DataSet ds = SqlDataAccess.ExecuteDatasetSP("User_UPD", parameters); return(int.Parse(ds.Tables[0].Rows[0][0].ToString())); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "UserUpdate"); return(-1); } }
public static int?UserInsert(User user, int iUserManagerId, int userType) { try { List <SqlParameter> parameters = ObjectGenerator <User> .GetSqlParametersFromObject(user); parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId)); parameters.Add(new SqlParameter("userType", userType)); if (userType == 3) { parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lLanguage, "int", "lLanguage")); parameters.Add(ObjectGenerator <int> .GenerateSimpleDataTableFromList(user.lOrderType, "int", "lOrderType")); } if (userType == 1) { user.iEntitlementTypeId = null; user.iCommunicationCart = null; } DataSet ds = SqlDataAccess.ExecuteDatasetSP("TUser_INS", parameters); return(int.Parse(ds.Tables[0].Rows[0][0].ToString())); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "UserInsert"); return(-1); } }
public static User Login(string nvUserName, string nvPassword) { try { SqlParameter[] param = { new SqlParameter("nvUserName", nvUserName), new SqlParameter("nvPassword", nvPassword) }; DataSet ds = SqlDataAccess.ExecuteDatasetSP("TUser_Login", param); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { User user = ObjectGenerator <User> .GeneratFromDataRow(ds.Tables[0].Rows[0]); return(user); } return(new User { iUserId = -1 }); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "Login"); return(null); } }
public static List <CategoryItem> GetCategoryItems(int iCatTypeId, int?iCatItemParentId, int?iCatItemParentId2) { try { List <CategoryItem> categoryItems = new List <CategoryItem>(); DataRowCollection drc = SqlDataAccess.ExecuteDatasetSP("TCategoryItem2_SLCT", new List <SqlParameter>() { new SqlParameter("iCatTypeId", iCatTypeId), new SqlParameter("iCatItemParentId", iCatItemParentId), new SqlParameter("iCatItemParentId2", iCatItemParentId2) }).Tables[0].Rows; foreach (DataRow dr in drc) { categoryItems.Add(ObjectGenerator <CategoryItem> .GeneratFromDataRow(dr)); } //var jsonText = File.ReadAllText(ConfigSettings.ReadSetting("DataFile")); //var result = JsonConvert.DeserializeObject<List<CategoryItem>>(jsonText); //if (iCatTypeId == 4 && iCatItemParentId == 0) // categoryItems = result.Where(x => x.iCatTypeId == 4 && x.iCatItemGrandParentId == iCatItemParentId2).ToList(); //else // categoryItems = result.Where(x => x.iCatTypeId == iCatTypeId && x.iCatItemParentId == iCatItemParentId).ToList(); return(categoryItems); } catch (Exception ex) { Log.LogError("GetCategoryItems / TCategoryItem_SLCT", "iCatItemParentId = " + iCatItemParentId + ", exception = " + ex); return(null); } }
public static string RefundUpdate(Refund refund, int iUserManagerId, bool isDelete, double prevRefund) { try { if (refund.nvDocPath != null) { if (isDelete == false) { if (refund.nvDocPath.Split(':')[0] == "data") { refund.nvDocPath = new FileManageCtrl().SaveFile(refund.nvDocPath.Substring(refund.nvDocPath.LastIndexOf(",") + 1), "reference", refund.nvDocPath.Substring(refund.nvDocPath.IndexOf('/') + 1, refund.nvDocPath.LastIndexOf(';') - refund.nvDocPath.IndexOf('/') - 1), iUserManagerId); } } else { refund.nvDocPath = refund.nvDocPath.Split('/')[4]; new FileManageCtrl().DeleteFile(refund.nvDocPath, "reference"); refund.nvDocPath = null; } } List <SqlParameter> parameters = ObjectGenerator <Refund> .GetSqlParametersFromObject(refund); parameters.Add(new SqlParameter("iUserManagerId", iUserManagerId)); parameters.Add(new SqlParameter("prevRefund", prevRefund)); DataSet ds = SqlDataAccess.ExecuteDatasetSP("TRefund_UPD", parameters); return("success"); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "RefundUpdate"); return(null); } }
public static List <KeyValue <int, string> > GetUsersCode(int?iUserType, int iStatusId, int?iTypeTranslation) { try { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("iUserType", iUserType)); parameters.Add(new SqlParameter("iStatusId", iStatusId)); parameters.Add(new SqlParameter("iTypeTranslation", iTypeTranslation)); //data set שולף אוסף של טבלאות DataTable dt = SqlDataAccess.ExecuteDatasetSP("TUserCode_SLCT", parameters).Tables[0]; List <KeyValue <int, string> > lusersCode = new List <KeyValue <int, string> >(); for (int i = 0; i < dt.Rows.Count; i++) { KeyValue <int, string> userCode = new KeyValue <int, string>(); userCode.iId = int.Parse(dt.Rows[i]["iId"].ToString()); userCode.nvName = dt.Rows[i]["nvName"].ToString(); lusersCode.Add(userCode); } return(lusersCode); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetUsersCode"); return(null); } }
public static twoList RecommendationAll() { twoList res = new twoList() { recommendations1 = new List <Recommendation>(), recommendations2 = new List <Recommendation>() }; try { DataSet ds = SqlDataAccess.ExecuteDatasetSP("All_Recommendation_SLCT"); if (ds.Tables[0].Rows.Count > 0) { res.recommendations1 = ObjectGenerator <Recommendation> .GeneratListFromDataRowCollection(ds.Tables[0].Rows); res.recommendations2 = ObjectGenerator <Recommendation> .GeneratListFromDataRowCollection(ds.Tables[1].Rows); } return(res); } catch (Exception x) { Log.LogError("RecommendationAll", x.Message); res = null; return(res); } }
public static bool UpdateStudent(Student student, string base64Image, int iUserId) { try { if (base64Image != "") { student.nvImgStudent = Fileshandler.SaveFileByBase64(base64Image, student.nvImgStudent, "Students//"); DataRow dr = SqlDataAccess.ExecuteDatasetSP("TStudentGetStudentbyId_SLCT", new SqlParameter("iPersonId", student.iPersonId)).Tables[0].Rows[0]; string prevName = ObjectGenerator <Student> .GeneratFromDataRow(dr).nvImgStudent; if (prevName != "") { Fileshandler.DeleteFile(prevName, "Students//"); } } List <SqlParameter> parameters = ObjectGenerator <Student> .GetSqlParametersFromObject(student); parameters.Add(new SqlParameter("iUserId", iUserId)); SqlDataAccess.ExecuteDatasetSP("TStudent_UPD", parameters); return(true); } catch (Exception ex) { Log.LogError("UpdateStudent / TStudent_UPD", "ex" + ex); return(false); } }
//להוסיף iPersonId //של היוזר ולשלוף את המשתתפים לפיו public static List <Person> GetParticipantsList(int iEventId) { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TParticipant_GetParticipantByEventId_SLCT", new SqlParameter("iEventId", iEventId)).Tables[0]; List <Person> participants = new List <Person>(); for (int i = 0; i < dt.Rows.Count; i++) { Person p = new Person(); p.nvLastName = dt.Rows[i]["nvLastName"].ToString(); p.nvFirstName = dt.Rows[i]["nvFirstName"].ToString(); p.nvPhone = dt.Rows[i]["nvPhone"].ToString(); p.nvMobile = dt.Rows[i]["nvMobile"].ToString(); p.nvEmail = dt.Rows[i]["nvEmail"].ToString(); p.lstObject.Add("iArrivalStatusType", dt.Rows[i]["iArrivalStatusType"].ToString()); p.lstObject.Add("nvParticipantType", dt.Rows[i]["nvParticipantType"].ToString()); participants.Add(p); } return(participants); } catch (Exception ex) { Log.LogError("GetParticipantsList / TParticipant_SLCT", "ex" + ex + ", iEventId : " + iEventId); return(null); } }
public static List <Settings> GetHMOs() { try { List <Settings> HMOs = new List <Settings>(); DataSet ds = SqlDataAccess.ExecuteDatasetSP("TLink_HMO_SLCT"); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { HMOs.Add(new Settings() { iSettingId = int.Parse(ds.Tables[0].Rows[i]["iSysTableConId"].ToString()), nvSetting = ds.Tables[0].Rows[i]["nvValue"].ToString() }); } } return(HMOs); } catch (Exception x) { Log.LogError("GetHMOs", x.Message); return(null); } }
public static int NewVideoTranslation(DateTime dtTimeBegin, DateTime dtTimeTranslation, string nvTranslatorIdentity, string nvUserIdentity) { try { List <SqlParameter> lParams = new List <SqlParameter>() { new SqlParameter("dtTimeBegin", dtTimeBegin), new SqlParameter("dtTimeTranslation", dtTimeTranslation), new SqlParameter("nvTranslatorIdentity", nvTranslatorIdentity), new SqlParameter("nvUserIdentity", nvUserIdentity) }; DataSet ds = SqlDataAccess.ExecuteDatasetSP("TOrder_Video_INS", lParams); if (ds.Tables[0].Rows.Count > 0) { int iOrderId = int.Parse(ds.Tables[0].Rows[0][0].ToString()); return(iOrderId); } return(0); } catch (Exception e) { Log.ExceptionLog(e.Message, "NewVideoTranslation"); return(-1); } }
//public static List<Document> GetImage() //{ // { // try // { // List<Document> documents = new List<Document>(); // DataRowCollection drc = SqlDataAccess.ExecuteDatasetSP("TDocuments_OfIMAGE_SLCT").Tables[0].Rows; // foreach (DataRow dr in drc) // { // documents.Add(ObjectGenerator<Document>.GeneratFromDataRow(dr)); // } // return documents; // } // catch (Exception ex) // { // Log.LogError("GetDocuments / TDocuments_OfStudents_SLCT", ", ex " + ex); // return null; // } public static int SetDocument(Document document, string nvBase64File, int iUserId) { try { if (nvBase64File != "") { document.nvDocumentName = Fileshandler.SaveFileByBase64(nvBase64File, document.nvDocumentName); if (document.iDocumentId != 0) { DataRow dr = SqlDataAccess.ExecuteDatasetSP("TDocuments_ByDocumentId_SLCT", new SqlParameter("iDocumentId", document.iDocumentId)).Tables[0].Rows[0]; string prevName = ObjectGenerator <Document> .GeneratFromDataRow(dr).nvDocumentName; Fileshandler.DeleteFile(prevName); } } List <SqlParameter> sqlParameters = ObjectGenerator <Document> .GetSqlParametersFromObject(document); sqlParameters.Add(new SqlParameter("iUserId", iUserId)); var dtCreatedate = sqlParameters.Where(s => s.ParameterName.Equals("dtCreatedate")).FirstOrDefault(); sqlParameters.Remove(dtCreatedate); //SqlDataAccess.ExecuteDatasetSP("TDocuments_INS/UPD", sqlParameters); //return true; int id = int.Parse(SqlDataAccess.ExecuteDatasetSP("TDocuments_INS/UPD", sqlParameters).Tables[0].Rows[0][0].ToString()); return(id); } catch (Exception ex) { Log.LogError("SetDocument /TDocuments_INS/upd", "ex: " + ex); return(0); } }
public static Dictionary <string, List <CodeTable> > GetListCodeTables(string sProcName, List <SqlParameter> parameters = null) { try { DataSet ds; if (parameters != null) { ds = SqlDataAccess.ExecuteDatasetSP(sProcName, parameters); } else { ds = SqlDataAccess.ExecuteDatasetSP(sProcName); } Dictionary <string, List <CodeTable> > codeTables = new Dictionary <string, List <CodeTable> >(); for (int i = 0; i < ds.Tables.Count; i++) { codeTables.Add(ds.Tables[i++].Rows[0][0].ToString(), ObjectGenerator <CodeTable> .GeneratListFromDataRowCollection(ds.Tables[i].Rows)); } return(codeTables); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetListCodeTables" + " , sProcName:" + sProcName); return(null); } }
public static User Login(string nvUserName, string nvPassword) { try { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("nvUserName", nvUserName)); parameters.Add(new SqlParameter("nvPassword", nvPassword)); DataRow dr; DataSet ds = SqlDataAccess.ExecuteDatasetSP("TUser_ByUserNameAndPassword_SLCT", parameters); if (ds.Tables[0].Rows.Count != 0) { dr = ds.Tables[0].Rows[0]; } else { dr = null; } User user; if (dr != null) { return(ObjectGenerator <User> .GeneratFromDataRow(dr)); } return(null); } catch (Exception ex) { Log.LogError("Login / TUser_ByUserNameAndPassword_SLCT", "nvUserName: "******", nvPassword:"******", ex " + ex); return(null); } }
public static List <UserBasic> GetUsersBasic(int?iUserType) { try { DataSet ds = SqlDataAccess.ExecuteDatasetSP("TSysUserBasic_SLCT", new SqlParameter("iUserType", iUserType)); List <UserBasic> lUsers = new List <UserBasic>(); DataView dv; foreach (DataRow dr in ds.Tables[0].Rows) { UserBasic user = new UserBasic(); user = ObjectGenerator <UserBasic> .GeneratFromDataRow(dr); dv = new DataView(ds.Tables[1], "iUserId = " + user.iUserId.ToString(), "", DataViewRowState.CurrentRows); user.lOrderType = new List <int>(); for (int j = 0; j < dv.Count; j++) { user.lOrderType.Add(int.Parse(dv[j]["iTypeId"].ToString())); } lUsers.Add(user); } return(lUsers); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetUsersBasic"); return(null); } }
public static ResObject <List <Contact> > GeContacts(string nvGuide) { ResObject <List <Contact> > res = new ResObject <List <Contact> >(); try { List <Contact> contacts = new List <Contact>(); DataSet ds = SqlDataAccess.ExecuteDatasetSP("TContact_SLCT", new SqlParameter("nvGuide", nvGuide)); if (ds.Tables[0].Rows[0][0].ToString() != string.Empty && int.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0) { res.Error = new ErrorObj(StatusCode.UserUnauthorized); res.Result = null; return(res); } if (ds != null && ds.Tables[1].Rows.Count > 0) { contacts = ObjectGenerator <Contact> .GeneratListFromDataRowCollection(ds.Tables[1].Rows); } res.Error = new ErrorObj(StatusCode.Success); res.Result = contacts; return(res); } catch (Exception x) { Log.LogError("GeContacts", x.Message); res.Error = new ErrorObj(StatusCode.Error, x.Message); res.Result = null; return(res); } }
public static List <Product> GetProduct() { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TSysProduct_SLCT").Tables[0]; List <Product> lProducts = new List <Product>(); for (int i = 0; i < dt.Rows.Count; i++) { Product product = new Product(); product.iProductId = int.Parse(dt.Rows[i]["iProductId"].ToString()); if (dt.Rows[i]["iProductTypeId"].ToString() != string.Empty) { product.iProductTypeId = int.Parse(dt.Rows[i]["iProductTypeId"].ToString()); } product.nvPruductName = dt.Rows[i]["nvPruductName"].ToString(); product.nvProductTypeId = dt.Rows[i]["nvProductTypeId"].ToString(); lProducts.Add(product); } return(lProducts); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetProduct"); return(null); } }
public static int NewRecommendationPhone(string nvHMO, string nvCity, string nvClinic, string nvDoctorName, string nvRecommendation, string nvFirstName, string nvMobile) { try { Log.LogInfo("recommendationPhone name: " + nvFirstName); List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("nvHMO", nvHMO), new SqlParameter("nvCity", nvCity), new SqlParameter("nvClinic", nvClinic), new SqlParameter("nvDoctorName", nvDoctorName), new SqlParameter("nvRecommendation", nvRecommendation), new SqlParameter("nvMobile", nvMobile), new SqlParameter("nvFirstName", nvFirstName) }; DataSet ds = SqlDataAccess.ExecuteDatasetSP("TRecommendationPhone_INS", parameters); int iRecommendationId = 0; if (ds != null && ds.Tables[0].Rows.Count > 0) { iRecommendationId = int.Parse(ds.Tables[0].Rows[0][0].ToString()); } return(iRecommendationId); } catch (Exception ex) { Log.LogError("NewRecommendationPhone / TRecommendationPhone_INS", ", exception = " + ex); return(-1); } }
public static bool SetEvent(Event1 oEvent, int iUserId, List <TInt> to) { try { bool isNew; isNew = oEvent.iEventId == 0 ? true : false; List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("iEventId", oEvent.iEventId)); parameters.Add(new SqlParameter("nvName", oEvent.nvName)); parameters.Add(new SqlParameter("dtEventDate", oEvent.dtEventDate)); parameters.Add(new SqlParameter("nvPlace", oEvent.nvPlace)); parameters.Add(new SqlParameter("nvComments", oEvent.nvComments)); parameters.Add(new SqlParameter("iUserId", iUserId)); parameters.Add(new SqlParameter("participantIds", ObjectGenerator <TInt> .GetDataTable(to))); if (!isNew) { SqlDataAccess.ExecuteDatasetSP("TEvent_INS/UPD", parameters); } if (isNew) { User user = User.GetUser(iUserId); DataRowCollection drc = SqlDataAccess.ExecuteDatasetSP("TEvent_INS/UPD", parameters).Tables[0].Rows; for (int i = 0; i < drc.Count; i++) { int iPersonId = int.Parse(drc[i]["iPersonId"].ToString()); string nvEmail = drc[i]["nvEmail"].ToString(); string body = "<b>הנך מוזמן ל" + oEvent.nvName + "</b><br>שיתקיים ב" + oEvent.nvPlace + "<br>בתאריך " + oEvent.dtEventDate + "<br>" + oEvent.nvComments + "<br><br> <b> בברכה </b> <br>" + user.nvFirstName + " " + user.nvLastName + "<br> עמותת ונתנו ידידים"; string from = user.nvEmail; if (user.nvEmail == "" || user.nvEmail == null) { from = ConfigSettings.ReadSetting("Email"); } if (SendMessagesHandler.SendEmailOrFax(from, nvEmail, oEvent.nvName, body, null) == true) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("iEventId", drc[i]["iEventId"])); param.Add(new SqlParameter("iPersonId", iPersonId)); param.Add(new SqlParameter("iStatusType", 34)); //סטטוס קיבל הודעה SqlDataAccess.ExecuteDatasetSP("TParticipantsUpdateArrivalStatus_UPD", param); } } //SendMessagesHandler.SendEmailOrFax() } return(true); } catch (Exception ex) { Log.LogError("set event / TEvent_INS/UPD", "ex" + ex); return(false); } }
public static void ExceptionLog(string exception, string function) { SqlParameter[] param = { new SqlParameter("nvException", exception), new SqlParameter("nvFunction", function) }; SqlDataAccess.ExecuteDatasetSP("TSysLog_INS", param); }
public static void YearOfRenewalUpdate() { try { SqlDataAccess.ExecuteDatasetSP("TYearOfRenewal_UPD"); Log.ExceptionLog("I enter", "YearOfRenewalUpdate"); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "YearOfRenewalUpdate"); } }
public static bool DeleteAvrech(int iPersonId) { try { SqlDataAccess.ExecuteDatasetSP("TAvrech_DEL", new SqlParameter("iPersonId", iPersonId)); return(true); } catch { return(false); } }
public static bool DeleteAvrechStudent(int iAvrechId, int iStudentId) { try { SqlDataAccess.ExecuteDatasetSP("TAvrechStudents_DEL", new SqlParameter("iAvrechId", iAvrechId), new SqlParameter("iStudentId", iStudentId)); return(true); } catch { return(false); } }
public static List <SysTableRow> GetSysTables() { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TSysTables_SLCT").Tables[0]; return(ObjectGenerator <SysTableRow> .GeneratListFromDataRowCollection(dt.Rows)); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "GetSysTables"); return(null); } }
public static string BankHoursUpdate() { try { SqlDataAccess.ExecuteDatasetSP("TBankHours_UPD"); return("OK"); } catch (Exception ex) { Log.ExceptionLog(ex.Message, "BankHoursUpdate"); return(null); } }
public static Year GetYear(int iYearId, bool bCategoryItem = true) { try { DataTableCollection dtc = SqlDataAccess.ExecuteDatasetSP("TYear_ById_SLCT", new List <SqlParameter>() { new SqlParameter("iYearId", iYearId), new SqlParameter("bCategoryItem", bCategoryItem) }).Tables; if (dtc[0].Rows.Count == 0) { return(null); } Year year = ObjectGenerator <Year> .GeneratFromDataRow(dtc[0].Rows[0]); List <CategoryItem> lCategoryItem = new List <CategoryItem>(); if (bCategoryItem) { foreach (DataRow dr in dtc[2].Rows) { lCategoryItem.Add(ObjectGenerator <CategoryItem> .GeneratFromDataRow(dr)); } } List <CategoryType> lCategoryType = new List <CategoryType>(); foreach (DataRow dr in dtc[1].Rows) { lCategoryType.Add(ObjectGenerator <CategoryType> .GeneratFromDataRow(dr)); lCategoryType.Last().lCategoryItem = lCategoryItem.Where(ci => ci.iCatTypeId == lCategoryType.Last().iCatTypeId).ToList(); } foreach (CategoryType ct in lCategoryType) { CategoryType cat = lCategoryType.Where(c => c.iCatTypeId == ct.iCatTypeParentId).FirstOrDefault(); if (cat != null) { cat.lCategoryType.Add(ct); } } year.lCategoryType = lCategoryType.Where(c => c.iCatTypeParentId == 0).ToList(); return(year); } catch (Exception ex) { Log.LogError("GetYear / TYear_SLCT", "iYearId = " + iYearId + ", exception = " + ex); return(null); } }
public static List <SysTables> GetAllNames() { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TSysTables_SLCT").Tables[0]; DataRowCollection drc = dt.Rows; return(ObjectGenerator <SysTables> .GeneratListFromDataRowCollection(drc)); } catch (Exception ex) { Log.LogError("GetAllNames / TSysTables_SLCT", ", ex " + ex); return(null); } }
public static List <TGlobalParameters> GetGlobalParameters() { try { DataTable dt = SqlDataAccess.ExecuteDatasetSP("TGlobalParameters_SLCT").Tables[0]; DataRowCollection drc = dt.Rows; return(ObjectGenerator <TGlobalParameters> .GeneratListFromDataRowCollection(drc)); } catch (Exception ex) { Log.LogError("SaveGlobalParameters / TGlobalParameters_SLCT", ", ex " + ex); return(null); } }
public static bool AddYeshiva(Yeshivot yeshiva) { try { List <SqlParameter> parameters = ObjectGenerator <Yeshivot> .GetSqlParametersFromObject(yeshiva); DataRow dr = SqlDataAccess.ExecuteDatasetSP("TYeshivot_INS", parameters).Tables[0].Rows[0]; return(true); } catch (Exception ex) { Log.LogError("AddYeshiva / TYeshivot_INS", "ex" + ex + ", yeshiva: " + JsonConvert.SerializeObject(yeshiva)); return(false); } }
public static List <Yeshivot> GetAllYeshivot() { try { DataRowCollection drc = SqlDataAccess.ExecuteDatasetSP("TYeshivot_SLCT").Tables[0].Rows; List <Yeshivot> yeshivots = ObjectGenerator <Yeshivot> .GeneratListFromDataRowCollection(drc); return(yeshivots); } catch (Exception ex) { Log.LogError("GetAllYeshivot / TYeshivot_SLCT", "ex: " + ex); return(null); } }