public static List<Data> GetData()
{
List<Data> DataList = new List<Data>();
bel_Product bel = new bel_Product();
dal_Product dal = new dal_Product();
bel._iMode = "Search";
DataSet ds = new DataSet();
ds = dal.dal_ProductDetail(bel);
foreach (DataRow row in ds.Tables[0].Rows)
{
Data thisData2 = new Data();
thisData2.SNo = row["SNo"].ToString();
thisData2.ProductCode = row["ProductCode"].ToString();
thisData2.Description = row["Description"].ToString();
DataList.Add(thisData2);
}
//Data thisData = new Data();
//thisData.SNo = "2";
//thisData.ProductCode = "Hawk";
//thisData.Description = "Aries";
//DataList.Add(thisData);
return DataList;
}
public DataSet dal_AutoGenDesign(bel_Product obj_bel_Product)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_AutoGenMaster");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@screenName", obj_bel_Product._ScreenName);
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public DataSet dal_ProductDetail(bel_Product obj_bel_Product)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_Product");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_Product._ProductID);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@CategoryID", obj_bel_Product._CategoryID);
sqlcmd.Parameters.AddWithValue("@Description", obj_bel_Product._Description);
sqlcmd.Parameters.AddWithValue("@UOMID", obj_bel_Product._UOMID);
sqlcmd.Parameters.AddWithValue("@BuyPrice", obj_bel_Product._BuyPrice);
sqlcmd.Parameters.AddWithValue("@SalePrice", obj_bel_Product._SalePrice);
// sqlcmd.Parameters.AddWithValue("@QualityID", obj_bel_Product._QualityID);
sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_Product._ProductCode);
sqlcmd.Parameters.AddWithValue("@ProductStatus", obj_bel_Product._ProductStatus);
sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_Product._CreatedOn);
sqlcmd.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_Product._ModifiedOn);
sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Product._iMode);
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_Product._ScreenName);
sqlcmd.Parameters.AddWithValue("@ProductGroupID", obj_bel_Product._ProductGroupID);
sqlcmd.Parameters.AddWithValue("@InventoryType", obj_bel_Product._InventoryType);
sqlcmd.Parameters.AddWithValue("@arno", obj_bel_Product._ARNO);
sqlcmd.Parameters.AddWithValue("@apno", obj_bel_Product._APNO);
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public int dal_ProductInsert(bel_Product obj_bel_Product, DataTable dt)
{
int value;
int i = 0;
int Result = 0;
string connectionString = ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
SqlTransaction trn;
connection.Open();
trn = connection.BeginTransaction();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_Product", connection, trn);
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
if (Convert.ToBoolean(Convert.ToInt32(obj_bel_Product._ProductID) != Convert.ToInt32(0)))
{
sqlcmd.Parameters.AddWithValue("@iMode", "Update");
sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_Product._ProductID);
}
else
{
sqlcmd.Parameters.AddWithValue("@iMode", "Insert");
sqlcmd.Parameters.AddWithValue("@ProductID", 0);
}
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@ProductGroupID", obj_bel_Product._ProductGroupID);
sqlcmd.Parameters.AddWithValue("@DesignID", obj_bel_Product._DesignID);
sqlcmd.Parameters.AddWithValue("@ColorID", obj_bel_Product._ColorID);
sqlcmd.Parameters.AddWithValue("@SizeID", obj_bel_Product._SizeID);
sqlcmd.Parameters.AddWithValue("@CategoryID", obj_bel_Product._CategoryID);
sqlcmd.Parameters.AddWithValue("@QualityID", obj_bel_Product._QualityID);
sqlcmd.Parameters.AddWithValue("@Description", obj_bel_Product._Description);
sqlcmd.Parameters.AddWithValue("@UOMID", obj_bel_Product._UOMID);
sqlcmd.Parameters.AddWithValue("@BuyPrice", obj_bel_Product._BuyPrice);
sqlcmd.Parameters.AddWithValue("@SalePrice", obj_bel_Product._SalePrice);
sqlcmd.Parameters.AddWithValue("@SKU", obj_bel_Product._SKU);
sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_Product._ProductCode);
sqlcmd.Parameters.AddWithValue("@ProductStatus", obj_bel_Product._ProductStatus);
sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_Product._CreatedOn);
sqlcmd.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_Product._ModifiedOn);
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_Product._ScreenName);
sqlcmd.Parameters.AddWithValue("@CombinedProductID", obj_bel_Product._CombinedProductID);
sqlcmd.Parameters.AddWithValue("@Quantity", obj_bel_Product._Quantity);
sqlcmd.Parameters.AddWithValue("@CombinedProduct", obj_bel_Product._CombinedProduct);
sqlcmd.Parameters.AddWithValue("@ProductDetailID", obj_bel_Product._ProductDetailID);
sqlcmd.Parameters.AddWithValue("@CurrencyID", obj_bel_Product._CurrencyID);
sqlcmd.Parameters.AddWithValue("@WarpWeft", obj_bel_Product._WarpWeft);
sqlcmd.Parameters.AddWithValue("@ReedPick", obj_bel_Product._ReedPick);
sqlcmd.Parameters["@ProductID"].Direction = ParameterDirection.InputOutput;
value = sqlcmd.ExecuteNonQuery();
val = (int)sqlcmd.Parameters["@ProductID"].Value;
SqlCommand sqlcmd2 = new SqlCommand("spu_Product", connection, trn);
sqlcmd2.CommandTimeout = 0;
sqlcmd2.CommandType = CommandType.StoredProcedure;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
sqlcmd2.Parameters.Clear();
if (Convert.ToString(dt.Rows[i]["CombinedProductID"]) == "0")
{
sqlcmd2.Parameters.AddWithValue("@iMode", "CombinedInsert");
sqlcmd2.Parameters.AddWithValue("@ProductID", Convert.ToInt32(val));
sqlcmd2.Parameters.AddWithValue("@CombinedProductID", 0);
}
else
{
sqlcmd2.Parameters.AddWithValue("@iMode", "CombinedUpdate");
sqlcmd2.Parameters.AddWithValue("@ProductID", Convert.ToInt32(val));
sqlcmd2.Parameters.AddWithValue("@CombinedProductID", dt.Rows[i]["CombinedProductID"]);
}
if (Convert.ToString(dt.Rows[i]["ProductDetailID"].ToString()) != string.Empty)
{
sqlcmd2.Parameters.AddWithValue("@ProductDetailID", Convert.ToInt32(dt.Rows[i]["ProductDetailID"].ToString()));
}
else
{
sqlcmd2.Parameters.AddWithValue("@ProductDetailID", 0);
}
if (Convert.ToString(dt.Rows[i]["Quantity"].ToString()) != string.Empty)
{
sqlcmd2.Parameters.AddWithValue("@Quantity", Convert.ToInt32(dt.Rows[i]["Quantity"].ToString()));
}
else
{
sqlcmd2.Parameters.AddWithValue("@Quantity", 0);
}
sqlcmd2.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd2.Parameters.AddWithValue("@ProductGroupID", obj_bel_Product._ProductGroupID);
sqlcmd2.Parameters.AddWithValue("@DesignID", obj_bel_Product._DesignID);
sqlcmd2.Parameters.AddWithValue("@ColorID", obj_bel_Product._ColorID);
sqlcmd2.Parameters.AddWithValue("@SizeID", obj_bel_Product._SizeID);
sqlcmd2.Parameters.AddWithValue("@CategoryID", obj_bel_Product._CategoryID);
sqlcmd2.Parameters.AddWithValue("@QualityID", obj_bel_Product._QualityID);
sqlcmd2.Parameters.AddWithValue("@Description", obj_bel_Product._Description);
sqlcmd2.Parameters.AddWithValue("@UOMID", obj_bel_Product._UOMID);
sqlcmd2.Parameters.AddWithValue("@BuyPrice", obj_bel_Product._BuyPrice);
sqlcmd2.Parameters.AddWithValue("@SalePrice", obj_bel_Product._SalePrice);
sqlcmd2.Parameters.AddWithValue("@SKU", obj_bel_Product._SKU);
sqlcmd2.Parameters.AddWithValue("@ProductCode", obj_bel_Product._ProductCode);
sqlcmd2.Parameters.AddWithValue("@ProductStatus", obj_bel_Product._ProductStatus);
sqlcmd2.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd2.Parameters.AddWithValue("@CreatedOn", obj_bel_Product._CreatedOn);
sqlcmd2.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd2.Parameters.AddWithValue("@ModifiedOn", obj_bel_Product._ModifiedOn);
sqlcmd2.Parameters.AddWithValue("@ScreenName", obj_bel_Product._ScreenName);
sqlcmd2.Parameters.AddWithValue("@CombinedProduct", obj_bel_Product._CombinedProduct);
sqlcmd2.Parameters.AddWithValue("@CurrencyID", obj_bel_Product._CurrencyID);
sqlcmd2.Parameters.AddWithValue("@WarpWeft", obj_bel_Product._WarpWeft);
sqlcmd2.Parameters.AddWithValue("@ReedPick", obj_bel_Product._ReedPick);
Result = sqlcmd2.ExecuteNonQuery();
}
trn.Commit();
Result = 1;
}
catch (SqlException ex)
{
trn.Rollback();
}
connection.Close();
return Result;
}
public static List<Dictionary<string, object>> search_(string page_name, string imode)
{
DataSet ds = new DataSet();
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
Dictionary<string, object> row = new Dictionary<string, object>();
try
{
switch (page_name)
{
case "CATEGORY":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Category obj_bel_Category = new bel_Category();
dal_Category obj_dal_Category = new dal_Category();
obj_bel_Category._iMode = imode;
using (ds = obj_dal_Category.dal_CategoryDetail(obj_bel_Category))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "CURRENCY":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Currency obj_bel_Currency = new bel_Currency();
dal_Currency obj_dal_Currency = new dal_Currency();
obj_bel_Currency._iMode = imode;
using (ds = obj_dal_Currency.dal_CurrencyDetail(obj_bel_Currency))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "PRODUCTGROUP":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_ProductGroup obj_bel_ProductGroup = new bel_ProductGroup();
dal_ProductGroup obj_dal_ProductGroup = new dal_ProductGroup();
obj_bel_ProductGroup._iMode = imode;
using (ds = obj_dal_ProductGroup.dal_ProductGroupDetail(obj_bel_ProductGroup))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "UOM":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_UOM obj_bel_UOM = new bel_UOM();
dal_UOM obj_dal_UOM = new dal_UOM();
obj_bel_UOM._iMode = imode;
using (ds = obj_dal_UOM.dal_UOMDetail(obj_bel_UOM))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "TAX":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Tax obj_bel_Tax = new bel_Tax();
dal_Tax obj_dal_Tax = new dal_Tax();
obj_bel_Tax._iMode = imode;
using (ds = obj_dal_Tax.dal_TAXDetail(obj_bel_Tax))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "Discount":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Discount obj_bel_Discount = new bel_Discount();
dal_Discount obj_dal_Discount = new dal_Discount();
obj_bel_Discount._iMode = imode;
using (ds = obj_dal_Discount.dal_DiscountDetail(obj_bel_Discount))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "BRANCH":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Branch obj_bel_Branch = new bel_Branch();
dal_Branch obj_dal_Branch = new dal_Branch();
obj_bel_Branch._iMode = imode;
using (ds = obj_dal_Branch.dal_Branchdetail(obj_bel_Branch))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "WAREHOUSE":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Warehouse obj_bel_Warehouse = new bel_Warehouse();
dal_Warehouse obj_dal_Warehouse = new dal_Warehouse();
obj_bel_Warehouse._iMode = imode;
using (ds = obj_dal_Warehouse.dal_WarehouseDetail(obj_bel_Warehouse))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "CUSTOMER":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Customer obj_bel_Customer = new bel_Customer();
dal_Customer obj_dal_Customer = new dal_Customer();
obj_bel_Customer._iMode = imode;
using (ds = obj_dal_Customer.dal_Customerdetail(obj_bel_Customer))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "PRODUCT":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Product obj_bel_Product = new bel_Product();
dal_Product obj_dal_Product = new dal_Product();
obj_bel_Product._iMode = imode;
using (ds = obj_dal_Product.dal_ProductDetail(obj_bel_Product))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "TASK":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Task obj_bel_Task = new bel_Task();
dal_Task obj_dal_Task = new dal_Task();
obj_bel_Task._iMode = imode;
using (ds = obj_dal_Task.dal_TaskDetail(obj_bel_Task))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "JOB":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_JobCreation obj_bel_Job = new bel_JobCreation();
dal_JobCreation obj_dal_Job = new dal_JobCreation();
obj_bel_Job._iMode = imode;
using (ds = obj_dal_Job.dal_JobCreationDetail(obj_bel_Job))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "SUBTYPE":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_SubType obj_bel_SubType = new bel_SubType();
dal_SubType obj_dal_SubType = new dal_SubType();
obj_bel_SubType._iMode = imode;
using (ds = obj_dal_SubType.dal_SubTypeDetail(obj_bel_SubType))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "CHARTOFACCOUNTS":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_ChartOfAccounts obj_bel_ChartOfAccounts = new bel_ChartOfAccounts();
dal_ChartOfAccounts obj_dal_ChartOfAccounts = new dal_ChartOfAccounts();
obj_bel_ChartOfAccounts._iMode = imode;
using (ds = obj_dal_ChartOfAccounts.dal_ChartOfAccountsDetail(obj_bel_ChartOfAccounts))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "USERCREATION":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_UserCreation obj = new bel_UserCreation();
dal_UserCreation dal = new dal_UserCreation();
obj._iMode = imode;
using (ds = dal.dal_UserCreationdetail(obj))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "SHIPPINGADDRESS":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_ShippingAddress obj_bel_shipping = new bel_ShippingAddress();
dal_ShippingAddress obj_dal_shipping = new dal_ShippingAddress();
obj_bel_shipping._iMode = imode;
using (ds = obj_dal_shipping.dal_ShippingDetail(obj_bel_shipping))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "COMPANY":
if (imode == "SEARCH" || imode == "DELETE")
{
bel_Company obj_bel_Company = new bel_Company();
dal_Company obj_dal_Company = new dal_Company();
obj_bel_Company._iMode = imode;
using (ds = obj_dal_Company.dal_Companydetail(obj_bel_Company))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
}
row.Add("res", "No Data");
rows.Add(row);
return rows;
}
catch (Exception ex)
{
row.Add("res", "exception");
rows.Add(row);
return rows;
}
}
public static List<Dictionary<string, object>> search_(string page_name, string imode)
{
DataSet ds = new DataSet();
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
Dictionary<string, object> row = new Dictionary<string, object>();
try
{
switch (page_name)
{
case "PURCHASEORDER":
if (imode == "PRINT")
{
bel_PurchaseOrder obj_bel_PurchaseOrder = new bel_PurchaseOrder();
dal_PurchaseOrder obj_dal_PurchaseOrder = new dal_PurchaseOrder();
obj_bel_PurchaseOrder._iMode = imode;
using (ds = obj_dal_PurchaseOrder.dal_PurchaseOrderDetail(obj_bel_PurchaseOrder))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "QUOTATION":
if (imode == "PRINT")
{
bel_Quotation obj_bel_Proforma = new bel_Quotation();
dal_Quotation obj_dal_Proforma = new dal_Quotation();
obj_bel_Proforma._iMode = imode;
using (ds = obj_dal_Proforma.dal_ProformaDetail(obj_bel_Proforma))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "SALESORDER":
if (imode == "PRINT")
{
bel_Salesorder obj_bel_DC = new bel_Salesorder();
dal_Salesorder obj_dal_DC = new dal_Salesorder();
obj_bel_DC._iMode = imode;
using (ds = obj_dal_DC.dal_DCDetail(obj_bel_DC))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
case "PRODUCT":
if (imode == "PRINT")
{
bel_Product obj_bel_Product = new bel_Product();
dal_Product obj_dal_Product = new dal_Product();
obj_bel_Product._iMode = imode;
using (ds = obj_dal_Product.dal_ProductDetail(obj_bel_Product))
{
return Json.getjson_(ds.Tables[0]);
}
}
break;
}
row.Add("res", "No Data");
rows.Add(row);
return rows;
}
catch (Exception ex)
{
row.Add("res", "exception");
rows.Add(row);
return rows;
}
}
