public static ResultBOL <DataSet> GetAll(int menuId) { string query = string.Format("select * from vw_Projects where MenuId = {0}", menuId); ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <string> UpdateIndex(OtherTypeUpdateIndexBOL[] list) { string stored = "sp_OtherType_Insert_Update"; ResultBOL <string> result = new ResultBOL <string>(); foreach (OtherTypeUpdateIndexBOL obj in list) { var updateResult = DataAccessHelpers.ExecuteStored(stored, obj.GetParameters()); if (updateResult.Code < 0) { if (string.IsNullOrEmpty(result.ErrorMessage)) { result.ErrorMessage = updateResult.ErrorMessage; } else { result.ErrorMessage += "\n" + updateResult.ErrorMessage; } } } if (!string.IsNullOrEmpty(result.ErrorMessage)) { result.Code = -1; } return(result); }
public static ResultBOL <DataSet> GetAll() { string query = "select * from vw_Projects"; ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public void ProcessRequest(HttpContext context) { string tag = "[AddContactHandler][ProcessRequest]"; LogHelpers.WriteStatus(tag, "Start..."); //--- ResultBOL <int> result; try { StreamReader reader = new StreamReader(context.Request.InputStream); string jsonRequest = reader.ReadToEnd(); //--- ContactBOL contact = JsonConvert.DeserializeObject <ContactBOL>(jsonRequest); contact.InsertDate = DateTime.Now; contact.UpdatedDate = DateTime.Now; //-- result = ContactsDAL.InsertOrUpdate(contact); } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); result = new ResultBOL <int>() { Code = ex.HResult, ErrorMessage = ex.Message }; } string jsonResponse = JsonConvert.SerializeObject(result); context.Response.ContentType = "application/json"; context.Response.Write(jsonResponse); }
public static ResultBOL <DataSet> GetAll() { string query = "select * from OtherType select * from Other where IsGroup = 1"; ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <int> InsertOrUpdate(GalleryBOL obj) { string stored = "sp_Galley_Insert_Update"; ResultBOL <int> result = DataAccessHelpers.ExecuteStored(stored, obj); if (result.Code < 0) { _log.Error(result.ErrorMessage); } else { obj.Id = result.Data; } return(result); }
private void GetLogo() { ResultBOL <DataSet> result = AboutsDAL.Get(); if (result.Code < 0) { _log.Error(result.ErrorMessage); } else if (result.Data != null && result.Data.Tables.Count > 0 && result.Data.Tables[0].Rows.Count > 0) { AboutBOL about = new AboutBOL(result.Data.Tables[0].Rows[0]); if (!string.IsNullOrEmpty(about.ImageLink)) { this.imgLogo.Src = "~/" + Path.Combine(Utilities.GetDirectory("ImagesDir"), about.ImageLink); } } }
public static int GetId(string type) { #if DEBUG _log.Debug("type: {0}", type); #endif string query = string.Format("select Id from Menu where [Type] like '{0}' and (ParentId is null or ParentId < 1)", type); ResultBOL <object> result = DataAccessHelpers.ExecuteScalar(query); if (result.Code < 0) { _log.Error(result.ErrorMessage); } else if (result.Data != null) { return(int.Parse(result.Data.ToString())); } return(int.MinValue); }
public void StartBidingOtherType(int id) { string tag = __tag + "[StartBidingOtherType]"; LogHelpers.WriteStatus(tag, "Start..."); lbError.Visible = false; try { ResultBOL <DataSet> result = null; if (id <= 0) { result = OtherTypeDAL.GetAll(); } else { result = OtherDAL.GetAll(id); } if (result.Code < 0) { lbError.InnerText = result.ErrorMessage; lbError.Visible = true; return; } _dataSource = result.Data.Tables[0]; grvOtherItems.DataSource = result.Data; grvOtherItems.DataKeyNames = new string[] { "Id" }; grvOtherItems.DataBind(); } catch (Exception ex) { LogHelpers.WriteException(tag, ex.ToString()); lbError.InnerText = ex.Message; lbError.Visible = true; } finally { LogHelpers.WriteStatus(tag, "End."); } }
public static ResultBOL <DataSet> GetAllGroup(int menuId) { #if DEBUG _log.Debug("menuId: {0}", menuId); #endif string query = "select * from Other where IsGroup = 1"; if (menuId > 0) { query += " and ParentId = " + menuId.ToString(); } ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); if (result.Code < 0) { _log.Error(result.ErrorMessage); } return(result); }