public A_ADM_ITEM_MASTER[] GetItemsDetails()
{
A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL();
var data = obj.GetItemsDetailsDb();
return(data);
}
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 bool InsertNewItem(U_ADM_ITEM_MASTER item)
{
A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL();
U_ADM_MEDIA_MASTERDAL objImg = new U_ADM_MEDIA_MASTERDAL();
U_ADM_MEDIA_MASTER imgData = new U_ADM_MEDIA_MASTER();
imgData.Media_Id = Guid.NewGuid().ToString();
imgData.Media_Type = "Image";
imgData.Media_File_Location = item.Media_Id_Img;
imgData.Media_Source = "";
imgData.Media_Oth_Dtl = "";
imgData.Created_by = item.Created_by;
imgData.Updated_by = item.Updated_by;
imgData.Created_Date = DateTime.Now;
imgData.Updated_Date = DateTime.Now;
item.Item_Id = imgData.Media_Id;
item.Item_Status = "1";
item.Item_Source = "No Source";
item.Media_Id_Video = " ";
item.Created_Date = DateTime.Now;
item.Updated_Date = DateTime.Now;
if (objImg.InsertU_ADM_MEDIA_MASTER(imgData))
{
item.Media_Id_Img = imgData.Media_Id;
if (obj.InsertU_ADM_ITEM_MASTER(item))
{
return(true);
}
}
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 string GetItemsCount()
{
A_ADM_ITEM_MASTERDAL ItemDAL = new A_ADM_ITEM_MASTERDAL();
return(ItemDAL.GetItemsCountDb());
}
public bool GetUnblockThisItem(string Id)
{
A_ADM_ITEM_MASTERDAL obj = new A_ADM_ITEM_MASTERDAL();
return(obj.GetUnblockThisItemDb(Id));
}
