public ActionResult UpdateItem(A_ADM_ITEM_MASTER item, HttpPostedFileBase newImg)
{
ItemsBLL ItemBLL = new ItemsBLL();
string Images = "";
if (!string.IsNullOrEmpty(Convert.ToString(newImg)))
{
if (Request.Files.Count > 0)
{
int i = 0;
HttpPostedFileBase files = Request.Files[i];
if (files.ContentLength > 0)
{
string filestoragename = Guid.NewGuid().ToString() + ".jpeg";
string directory = Server.MapPath("~/images/");
string path = Path.Combine(directory, filestoragename);
files.SaveAs(path);
Images = filestoragename;
}
}
item.Item_PicUrl = string.IsNullOrEmpty(Images) ? "/img/default_product.png" : "/images/" + Images;
}
item.Update_By = Convert.ToString(Session["AdminId"]);
bool status = ItemBLL.UpdateItem(item);
return(RedirectToAction("Index", "GiftItems"));
}
public A_ADM_ITEM_MASTER GetSingleItemDetails(string id)
{
A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL();
A_ADM_ITEM_MASTER data = obj.GetSingleItemDetailsDb(id);
return(data);
}
public ActionResult EditItem(string id)
{
ItemsBLL ItemBLL = new ItemsBLL();
A_ADM_ITEM_MASTER Item = ItemBLL.GetSingleItemDetails(id);
return(View(Item));
}
public ActionResult ItemDetails(string id)
{
ItemsBLL obj = new ItemsBLL();
A_ADM_ITEM_MASTER item = obj.GetSingleItemDetails(id);
return(View(item));
}
public A_ADM_ITEM_MASTER GetSingleItemDetailsDb(string id)
{
SqlConnection con = null;
SqlParameter[] aParms = new SqlParameter[] { new SqlParameter(PARAM_Item_Id, id) };
A_ADM_ITEM_MASTER item = new A_ADM_ITEM_MASTER();
try
{
con = General.GetConnection();
SqlDataReader reader = SqlHelper.ExecuteReader(con, CommandType.Text, SQL_Select_Single_Item, aParms);
while (reader.Read())
{
item.Item_ID = reader.GetString(0);
item.Item_PicUrl = reader.GetString(1);
item.Item_Name = reader.GetString(2);
item.Item_Desc = reader.GetString(3);
item.Item_Status = reader.GetString(4);
item.Item_Price = reader.GetDecimal(5);
item.Item_Source = reader.GetString(6);
}
reader.Close();
return(item);
}
catch (Exception e)
{
Console.Write(e);
return(null);
}
}
public bool UpdateItem(A_ADM_ITEM_MASTER item)
{
try
{
StreamReader readStream;
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(@"http://" + GeneralBLL.Service_Link + "/Services/AdminService.svc/UpdateItem");
httpWebRequest.Method = "POST";
httpWebRequest.ContentType = @"application/json; charset=utf-8";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = new JavaScriptSerializer().Serialize(item);
streamWriter.Write(json);
}
HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
readStream = new StreamReader(httpResponse.GetResponseStream());
var serializer = new DataContractJsonSerializer(typeof(bool));
bool obj = Convert.ToBoolean(serializer.ReadObject(readStream.BaseStream));
return(obj);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
public bool UpdateItem(A_ADM_ITEM_MASTER item)
{
A_ADM_ITEM_MASTERDAL ItemDAL = new A_ADM_ITEM_MASTERDAL();
U_ADM_ITEM_MASTER OldData = new U_ADM_ITEM_MASTER();
U_ADM_ITEM_MASTER NewData = new U_ADM_ITEM_MASTER();
U_ADM_MEDIA_MASTERDAL ImgDAL = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
OldData = ItemDAL.SelectItemDetailsDb(item.Item_ID);
if (!(item.Item_PicUrl == "/img/default_product.png") && !(string.IsNullOrEmpty(item.Item_PicUrl)))
{
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = item.Item_PicUrl;
imgData.Media_Source = "";
imgData.Media_Oth_Dtl = "";
imgData.Created_by = item.Update_By;
imgData.Updated_by = item.Update_By;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
ImgDAL.InsertU_ADM_MEDIA_MASTER(imgData);
NewData.Media_Id_Img = imgData.Media_Id;
}
else
{
NewData.Media_Id_Img = OldData.Media_Id_Img;
}
NewData.Item_Id = item.Item_ID;
NewData.Item_Name = string.IsNullOrEmpty(item.Item_Name) ? OldData.Item_Name : item.Item_Name;
NewData.Item_Desc = string.IsNullOrEmpty(item.Item_Desc) ? OldData.Item_Desc : item.Item_Desc;
NewData.Item_Status = string.IsNullOrEmpty(item.Item_Status) ? OldData.Item_Status : item.Item_Status;
NewData.Item_Tentative_Cost = string.IsNullOrEmpty(Convert.ToString(item.Item_Price)) ? OldData.Item_Tentative_Cost : item.Item_Price;
NewData.Item_Source = string.IsNullOrEmpty(item.Item_Source) ? OldData.Item_Source : item.Item_Source;
NewData.Media_Id_Video = OldData.Media_Id_Video;
NewData.Created_by = OldData.Created_by;
NewData.Created_Date = OldData.Created_Date;
NewData.Updated_by = string.IsNullOrEmpty(item.Update_By) ? OldData.Updated_by : item.Update_By;
NewData.Updated_Date = DateTime.Now;
if (ItemDAL.UpdateItemMaster(NewData))
{
return(true);
}
return(false);
}
public A_ADM_ITEM_MASTER GetSingleItemDetails(string id)
{
try
{
StreamReader readStream;
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(@"http://" + GeneralBLL.Service_Link + "/Services/AdminService.svc/SingleItemDetails/" + id);
httpWebRequest.Method = "GET";
httpWebRequest.ContentType = @"application/json; charset=utf-8";
HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
readStream = new StreamReader(httpResponse.GetResponseStream());
var serializer = new DataContractJsonSerializer(typeof(A_ADM_ITEM_MASTER));
A_ADM_ITEM_MASTER obj = serializer.ReadObject(readStream.BaseStream) as A_ADM_ITEM_MASTER;
return(obj);
}
catch (Exception e)
{
Console.Write(e);
return(null);
}
}
