public static ProductOrganiztionImageInfo GetDetails_ProductOrganizationImage(string ImageId, string OrganizationproductId, string ProductID, string IsActive, string IsMain)
{
var list = GetList_ProductOrganizationImage(ImageId, OrganizationproductId, ProductID, IsActive, IsMain);
if (list != null && list.Count() > 0)
{
return(list[0]);
}
ProductOrganiztionImageInfo objProductOrganiztionImageInfo = new ProductOrganiztionImageInfo();
objProductOrganiztionImageInfo.ImageId = 0;
objProductOrganiztionImageInfo.IsActive = "";
objProductOrganiztionImageInfo.Ismain = "";
objProductOrganiztionImageInfo.OrganizationproductId = 0;
return(objProductOrganiztionImageInfo);
}
public static bool Save_ProductOrganizationImage(bool isOnlyDelete, ProductOrganiztionImageInfo obj, UserInfo objUserInfo, out string errormsg)
{
errormsg = "";
flag = false;
#region Validations
if (isOnlyDelete)
{
if (obj.ImageId < 1)
{
errormsg = "Image identity should come"; return(false);
}
}
else
{
if (!Validations.ValidateDataType(obj.FileName, Validations.ValueType.AlphaNumericSpecialChar, false, "File Name", out errormsg))
{
return(false);
}
if (!Validations.ValidateDataType(obj.FileType, Validations.ValueType.AlphaNumericSpecialChar, true, "File Type", out errormsg))
{
return(false);
}
}
#endregion
using (DBHelper dbhlper = new DBHelper("[spMAPOrganizationproductImageSave]", true))
{
DBHelper.AddPparameter("@ImageId", obj.ImageId, DBHelper.param_types.BigInt);
DBHelper.AddPparameter("@OrganizationproductId", obj.OrganizationproductId, DBHelper.param_types.BigInt);
DBHelper.AddPparameter("@ProductId", obj.ProductId.Trim().Length > 0 ? Convert.ToInt32(obj.ProductId) : 0, DBHelper.param_types.BigInt);
DBHelper.AddPparameter("@FileData", obj.FileData == null ? new byte[] { } : obj.FileData, DBHelper.param_types.Image);
DBHelper.AddPparameter("@FileName", obj.FileName, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@FileType", obj.FileType, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@Seq", obj.Seq, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@IsMain", obj.Ismain.Trim().ToUpper(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@IsActive", obj.IsActive.Trim().ToUpper(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? "Y" : "N"), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@NewDatauniqueID", 0, DBHelper.param_types.BigInt, 50, DBHelper.param_direction.Output);
DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output);
return(DBHelper.Execute_NonQuery(out errormsg));
}
}
public static List <ProductOrganiztionImageInfo> GetList_ProductOrganizationImage(string ImageId, string OrganizationproductId, string ProductID, string IsActive, string IsMain)
{
using (DBHelper dbhlper = new DBHelper("[spMAPOrganizationproductImageGet]"))
{
DBHelper.AddPparameter("@ImageId", ImageId);
DBHelper.AddPparameter("@OrganizationproductId", OrganizationproductId.Trim().Length > 0 ? Convert.ToInt32(OrganizationproductId) : 0);
DBHelper.AddPparameter("@ProductId", ProductID.Trim().Length > 0 ? Convert.ToInt32(ProductID) : 0);
DBHelper.AddPparameter("@IsActive", IsActive);
DBHelper.AddPparameter("@IsMain", IsMain);
using (DataSet ds = DBHelper.Execute_Query())
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <ProductOrganiztionImageInfo> list = new List <ProductOrganiztionImageInfo>();
ProductOrganiztionImageInfo obj = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new ProductOrganiztionImageInfo();
obj.ImageId = dr["ImageId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ImageId"]);
obj.OrganizationproductId = dr["OrganizationproductId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["OrganizationproductId"]);
obj.ProductId = dr["ProductID"].ToString();
obj.FileData = dr["FileData"] == DBNull.Value ? new Byte[] { } : (byte[])dr["FileData"];
obj.FileName = dr["FileName"].ToString();
obj.FileType = dr["FileType"].ToString();
obj.Seq = dr["SEQ"] == DBNull.Value ? 0 : Convert.ToInt32(dr["SEQ"]);
obj.Ismain = dr["isMain"].ToString().Trim().ToUpper();
obj.IsActive = dr["IsActive"].ToString().Trim().ToUpper();
list.Add(obj);
}
return(list);
}
}
}
return(null);
}
public ActionResult Save_ProductOrganizationImage(string isOnlyDelete, string ImageId, string OrganizationproductId, string ProductId, string IsMain, string IsActive, HttpPostedFileBase[] files)
{
string fileName = "", path = "";
using (Product_Svc.ProductServiceClient iGstSvc = new Product_Svc.ProductServiceClient())
{
ProductOrganiztionImageInfo objProduct = null;
if (files == null && isOnlyDelete.Trim().ToUpper() == "Y")
{
objProduct = new ProductOrganiztionImageInfo();
objProduct.OrganizationproductId = OrganizationproductId.Trim().Length == 0 ? 0 : Convert.ToInt32(OrganizationproductId.Trim());
objProduct.ProductId = ProductId;
objProduct.ImageId = ImageId.Trim().Length == 0 ? 0 : Convert.ToInt32(ImageId);
objProduct.IsActive = IsActive.Trim().ToUpper();
objProduct.Ismain = IsMain.Trim().ToUpper();
objProduct.IsActive = IsActive.Trim().ToUpper();
if (iGstSvc.Save_ProductOrganizationImage(isOnlyDelete.Trim().ToUpper() == "Y", objProduct, ((UserInfo)Session["UserDetails"]), out ErrorMessage))
{
//If delete success then file should be deleted
if (isOnlyDelete.Trim().ToUpper() == "Y")
{
try
{
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex) { ErrorMessage = ErrorMessage + ex.Message; }
}
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
}
if (files != null)
{
foreach (HttpPostedFileBase file in files)
{
objProduct = new ProductOrganiztionImageInfo();
if (ImageId.Trim().Replace("0", "").Length == 0)
{
fileName = Guid.NewGuid().ToString() + System.IO.Path.GetExtension(file.FileName);
path = System.IO.Path.Combine(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["UploadDataPath"].ToString()), fileName);
file.SaveAs(path);
objProduct.FileName = fileName;
objProduct.FileType = file.ContentType;
}
objProduct.OrganizationproductId = OrganizationproductId.Trim().Length == 0 ? 0 : Convert.ToInt32(OrganizationproductId.Trim());
objProduct.ProductId = ProductId;
objProduct.ImageId = ImageId.Trim().Length == 0 ? 0 : Convert.ToInt32(ImageId);
objProduct.IsActive = IsActive.Trim().ToUpper();
objProduct.Ismain = IsMain.Trim().ToUpper();
objProduct.IsActive = IsActive.Trim().ToUpper();
if (iGstSvc.Save_ProductOrganizationImage(isOnlyDelete.Trim().ToUpper() == "Y", objProduct, ((UserInfo)Session["UserDetails"]), out ErrorMessage))
{
//If delete success then file should be deleted
if (isOnlyDelete.Trim().ToUpper() == "Y")
{
try
{
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex) { ErrorMessage = ErrorMessage + ex.Message; }
if (ErrorMessage.Trim().Length > 0 && ImageId.Trim().Replace("0", "").Length == 0)
{
try
{
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
}
catch (Exception ex) { ErrorMessage = ErrorMessage + ex.Message; }
}
return(Json(ErrorMessage, JsonRequestBehavior.AllowGet));
}
}
}
}
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
return(Json(ErrorMessage, JsonRequestBehavior.AllowGet));
}
public bool Save_ProductOrganizationImage(bool isOnlyDelete, ProductOrganiztionImageInfo obj, UserInfo objUserInfo, out string errormsg)
{
return(wscalls.Save_ProductOrganizationImage(isOnlyDelete, obj, objUserInfo, out errormsg));
}
