public static DbStatusEntity[] UpdateData(BannerImageEntity obj, int id) //Update data in database { var details = new List <DbStatusEntity>(); try { details.Add(new BannerMasterDAO().UpdateBanner(obj, id)); } catch (Exception ex) { details.Clear(); details.Add(new DbStatusEntity(ex.Message)); } return(details.ToArray()); }
public List <BannerImageEntity> EditBanner(Int64 id) { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; SqlDataAdapter adapter; DataSet ds = new DataSet(); List <BannerImageEntity> retlst = new List <BannerImageEntity>(); try { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("USP_GetBannerDetailsbyID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", id); con.Open(); adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { BannerImageEntity obj = new BannerImageEntity(); obj.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString()); obj.HEADING = ds.Tables[0].Rows[i]["HEADING"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["HEADING"].ToString(); obj.DESCRIPTION = ds.Tables[0].Rows[i]["DESCRIPTION"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["DESCRIPTION"].ToString(); obj.ORG_FILE_NAME = ds.Tables[0].Rows[i]["ORG_FILE_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["ORG_FILE_NAME"].ToString(); obj.PHY_FILE_NAME = ds.Tables[0].Rows[i]["PHY_FILE_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["PHY_FILE_NAME"].ToString(); obj.FCOLOR = ds.Tables[0].Rows[i]["FCOLOR"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["FCOLOR"].ToString(); obj.SORT_ORDER = ds.Tables[0].Rows[i]["SORT_ORDER"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["SORT_ORDER"].ToString()); retlst.Add(obj); } } } catch (Exception ex) { throw ex; } return(retlst); }
public DbStatusEntity InsertBanner(BannerImageEntity obj) { DbStatusEntity objreturn = new DbStatusEntity(); string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; try { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("USP_InsertBannerMaster", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HEADING", obj.HEADING); cmd.Parameters.AddWithValue("@DESCRIPTION", obj.DESCRIPTION); cmd.Parameters.AddWithValue("@ORG_FILE_NAME", obj.ORG_FILE_NAME); cmd.Parameters.AddWithValue("@PHY_FILE_NAME", obj.PHY_FILE_NAME); cmd.Parameters.AddWithValue("@FCOLOR", obj.FCOLOR); cmd.Parameters.Add("@RESULT", SqlDbType.Int); cmd.Parameters["@RESULT"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@CNT", SqlDbType.Int); cmd.Parameters["@CNT"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@MSG", SqlDbType.NVarChar, 500); cmd.Parameters["@MSG"].Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); objreturn.RESULT = Convert.ToInt32(cmd.Parameters["@RESULT"].Value); objreturn.CNT = Convert.ToInt32(cmd.Parameters["@CNT"].Value); objreturn.MSG = Convert.ToString(cmd.Parameters["@MSG"].Value); con.Close(); } } catch (Exception ex) { throw ex; } return(objreturn); }
public void ProcessRequest(HttpContext context) { if (context.Request.QueryString["action"] != null) { actiontype = context.Request.QueryString["action"].ToString(); if (actiontype.Trim().ToUpper() == "UPLOAD") { //for uploading new File folderpath = System.Configuration.ConfigurationManager.AppSettings["FolderPath"]; var postedFile = context.Request.Files[0]; string filesize = System.Configuration.ConfigurationManager.AppSettings["FileSize"]; mFileSize = postedFile.ContentLength / 1048576; string Savepath = context.Server.MapPath("~//" + folderpath); if (mFileSize <= Convert.ToInt32(filesize)) { // Get Server Folder to upload file phy_file_name = context.Request.QueryString["phy_file_name"].ToString(); org_file_name = context.Request.QueryString["org_file_name"].ToString(); heading = context.Request.QueryString["heading"].ToString(); desc = context.Request.QueryString["desc"].ToString(); fcolor = context.Request.QueryString["fcolor"].ToString(); if (!Directory.Exists(Savepath)) { Directory.CreateDirectory(Savepath); } postedFile.SaveAs(Savepath + "\\" + phy_file_name); BannerImageEntity objimg = new BannerImageEntity(); objimg.HEADING = heading; objimg.DESCRIPTION = desc; objimg.ORG_FILE_NAME = org_file_name; objimg.PHY_FILE_NAME = phy_file_name; objimg.FCOLOR = fcolor; List <DbStatusEntity> details = new List <DbStatusEntity>(); details.Add(new BannerMasterDAO().InsertBanner(objimg)); //Set response message string msg = "{"; msg += string.Format("error:'{0}',\n", string.Empty); msg += string.Format("upfile:'{0}'\n", phy_file_name); msg += "}"; context.Response.Write(msg); } } else if (actiontype.Trim().ToUpper() == "DELETE") { folderpath = System.Configuration.ConfigurationManager.AppSettings["FolderPath"]; id = context.Request.QueryString["id"].ToString(); List <BannerImageEntity> objimg = new List <BannerImageEntity>(); objimg = new BannerMasterDAO().EditBanner(Convert.ToInt64(id)); if (objimg.Count > 0) { phy_file_name = objimg[0].PHY_FILE_NAME; } string Savepath = context.Server.MapPath("~//" + folderpath); if (File.Exists(Savepath + "\\" + phy_file_name)) { File.Delete(Savepath + "\\" + phy_file_name); } List <DbStatusEntity> details = new List <DbStatusEntity>(); details.Add(new BannerMasterDAO().DeleteBanner(Convert.ToInt64(id))); } else if (actiontype.Trim().ToUpper() == "DOWNLOAD") { folderpath = System.Configuration.ConfigurationManager.AppSettings["FolderPath"]; id = context.Request.QueryString["id"].ToString(); List <BannerImageEntity> objimg = new List <BannerImageEntity>(); objimg = new BannerMasterDAO().EditBanner(Convert.ToInt64(id)); if (objimg.Count > 0) { phy_file_name = objimg[0].PHY_FILE_NAME; org_file_name = objimg[0].ORG_FILE_NAME; } string Savepath = context.Server.MapPath("~//" + folderpath); if (File.Exists(Savepath + "\\" + phy_file_name)) { context.Response.Clear(); context.Response.ContentType = "application/octet-stream"; context.Response.AddHeader("Content-Disposition", string.Format("attachment; filename=\"{0}\"", org_file_name)); context.Response.WriteFile(Savepath + "\\" + phy_file_name); context.Response.Flush(); } } } }