public int Update_Product_Package_Data_Master(Prod_Dealer_Requested_product obj)
{
int flag = _dealerDal.Update_Product_Package_Data_Master(obj);
return(flag);
}
public int Update_Product_Package_Data_Master(Prod_Dealer_Requested_product objProducttemp)
{
string sql = "";
DataSet ds = new DataSet();
int iResult = 0;
int iSuccess = 0;
try
{
//if (objProducttemp.createdBy > 0)
// objProducttemp.createdDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
sql = StoredProcedure.Update_Product_Package_Data_Master;
SqlParameter[] parameters = new SqlParameter[31];
parameters[0] = new SqlParameter("@OldProductId", objProducttemp.productID);
parameters[1] = new SqlParameter("@ProductType", objProducttemp.productType);
parameters[2] = new SqlParameter("@productName", objProducttemp.productName);
parameters[3] = new SqlParameter("@TechnicalId", objProducttemp.technicalId);
parameters[4] = new SqlParameter("@BrandId", objProducttemp.brandId);
parameters[5] = new SqlParameter("@ProductStateId", objProducttemp.ProductState);
parameters[6] = new SqlParameter("@Dosage", objProducttemp.DosageDescription);
parameters[7] = new SqlParameter("@ApplyOnCrop", objProducttemp.applyOnCrop);
parameters[8] = new SqlParameter("@Target", objProducttemp.target);
parameters[9] = new SqlParameter("@ProductDesc", objProducttemp.Description);
parameters[10] = new SqlParameter("@Remark", objProducttemp.remarks);
parameters[11] = new SqlParameter("@CreateBy", objProducttemp.createdBy);
//if (objProducttemp.createdBy > 0)
// parameters[12] = new SqlParameter("@CreatedDate", objProducttemp.createdDate);
//parameters[13] = new SqlParameter("@ModifiedBy", objProducttemp.createdBy);
//if (objProducttemp.createdBy > 0)
// parameters[14] = new SqlParameter("@ModifiedDate", objProducttemp.createdDate);
parameters[12] = new SqlParameter("@PackageTypeId", objProducttemp.packageTypeId);
parameters[13] = new SqlParameter("@QualityId", objProducttemp.QualityId);
parameters[14] = new SqlParameter("@CropID", objProducttemp.cropID);
parameters[15] = new SqlParameter("@Disease", objProducttemp.Disease);
parameters[16] = new SqlParameter("@FeedType", objProducttemp.FeedType);
parameters[17] = new SqlParameter("@FeedState", objProducttemp.FeedState);
parameters[18] = new SqlParameter("@status", objProducttemp.status);
parameters[19] = new SqlParameter("@ProductId", 0);
parameters[19].Direction = ParameterDirection.Output;
parameters[20] = new SqlParameter("@size", objProducttemp.size);
parameters[21] = new SqlParameter("@Unit", objProducttemp.unitId);
parameters[22] = new SqlParameter("@MRP", objProducttemp.mrp);
parameters[23] = new SqlParameter("@packageId", objProducttemp.packageID);
parameters[24] = new SqlParameter("@DealerID", objProducttemp.dealerID);
parameters[25] = new SqlParameter("@DealerPrice", objProducttemp.dealerPrice);
parameters[26] = new SqlParameter("@othercharges", objProducttemp.otherCharges);
parameters[27] = new SqlParameter("@ourPrice", objProducttemp.ourPrice);
parameters[28] = new SqlParameter("@Qty", objProducttemp.qty);
parameters[29] = new SqlParameter("@DistrictID", objProducttemp.districtId);
parameters[30] = new SqlParameter("@IsActive", objProducttemp.isActive);
iResult = BaseDal.ExecuteNonQuerywithSP(sql, parameters);
iSuccess = Convert.ToInt32(parameters[19].Value);
}
catch (Exception ex)
{
LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0);
}
return(iSuccess);
}
