public int Insert_WArticle(WArticleInfo wArticle)
{
int wArticle_Id = 0;
_sqlRepo.ExecuteNonQuery(Set_Values_In_WArticle(wArticle), StoredProcedures.Insert_W_Article_Sp.ToString(), CommandType.StoredProcedure);
return(wArticle_Id);
}
public void Delete_Vendor_By_Id(int consumable_vendor_Id)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@Consumable_Vendor_Id", consumable_vendor_Id));
_sqlRepo.ExecuteNonQuery(sqlparam, StoredProcedures.Delete_Vendor_By_Id.ToString(), CommandType.StoredProcedure);
}
public void Update_Work_Station(WorkStationInfo work_Station)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Work_Station(work_Station), StoredProcedures.Update_Work_Station_sp.ToString(), CommandType.StoredProcedure);
if (!string.IsNullOrEmpty(work_Station.Process_Ids))
{
Insert_Work_Station_Process(work_Station.Process_Ids, work_Station.Work_Station_Id);
}
}
public void Delete_Attachment_By_Id(long attachment_Id)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Attachment_Id", attachment_Id));
sqlRepo.ExecuteNonQuery(sqlParams, StoredProcedures.Delete_Attachment_By_Id.ToString(), CommandType.StoredProcedure);
}
public void Insert_Role_Access(int RoleId, int[] Access_Ids)
{
foreach (var item in Access_Ids)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
sqlparam.Add(new SqlParameter("@Role_Id", RoleId));
sqlparam.Add(new SqlParameter("@Access_Id", item));
sqlparam.Add(new SqlParameter("@CreatedBy", 1));
sqlparam.Add(new SqlParameter("@UpdatedBy", 1));
sqlRepo.ExecuteNonQuery(sqlparam, StoredProcedures.Insert_Role_Access_Sp.ToString(), CommandType.StoredProcedure);
}
}
public void Update_Industrial(IndustrialInfo industrialInfo)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Industrial(industrialInfo), StoredProcedures.Update_Industrial_Master_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Customer_Quality(CustomerQualityInfo customer_Quality)
{
_sqlRepo.ExecuteNonQuery(Set_Updated_Values_In_Customer_Quality(customer_Quality), StoredProcedures.Update_Customer_Quality_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert(TestUnitInfo testUnit)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Test_Unit(testUnit), StoredProcedures.Insert_Test_Unit_sp.ToString(), CommandType.StoredProcedure);
}
public void Insert_Packing(PackingInfo PackingInfo)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Packing(PackingInfo), StoredProcedures.Insert_Packing_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_User(UserInfo userInfo)
{
sqlRepo.ExecuteNonQuery(SetValues_In_User(userInfo), StoredProcedures.Update_User_Sp.ToString(), CommandType.StoredProcedure);
Insert_User_Role_Mapping(userInfo.Role_Ids, userInfo.UserId);
}
public void Update_YArticle(YArticleInfo yArticle)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_YArticle(yArticle), StoredProcedures.Update_Y_Article_sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Quality(QualityInfo quality)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Quality(quality), StoredProcedures.Update_Quality_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert(DefectInfo defects)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Defects(defects), StoredProcedures.Insert_Defect_sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Complaint(ComplaintInfo complaintInfo)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Complaint(complaintInfo), StoredProcedures.Update_Complaint_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_PArticle(PArticleInfo pArticle)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_PArticle(pArticle), StoredProcedures.Update_P_Article_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Customer(CustomerInfo customer)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Customer(customer), StoredProcedures.Update_Customer_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert(AttributeCodeInfo attributeCode)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Attribute_Code(attributeCode), StoredProcedures.Insert_Attribute_Code_sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Role(RoleInfo RoleInfo)
{
sqlRepo.ExecuteNonQuery(SetValues_In_Role(RoleInfo), StoredProcedures.Update_Role_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Enquiry(EnquiryInfo enquiry)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Enquiry(enquiry), StoredProcedures.Update_Enquiry_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Contact(ContactInfo contact)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Contact(contact), StoredProcedures.Update_Contact_sp.ToString(), CommandType.StoredProcedure);
}
//public int Insert_Product_Services(ProductVendorInfo productVendors)
//{
// int Product_Vendor_Id = 0;
// Product_Vendor_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Product_Vendors(productVendors), StoredProcedures.Insert_Product_Vendors_sp.ToString(), CommandType.StoredProcedure));
// return Product_Vendor_Id;
//}
//private List<SqlParameter> Set_Values_In_Product_Vendors(ProductVendorInfo productVendorInfo)
//{
// List<SqlParameter> sqlParamList = new List<SqlParameter>();
//sqlParamList.Add(new SqlParameter("@Vendor_Id", productVendorInfo.Product_Vendor_Entity.Vendor_Id));
//sqlParamList.Add(new SqlParameter("@Product_Type", productVendorInfo.Product_Vendor_Entity.Product_Type));
//sqlParamList.Add(new SqlParameter("@Name", productVendorInfo.Product_Vendor_Entity.Name));
//sqlParamList.Add(new SqlParameter("@Original_Manufacturer", productVendorInfo.Product_Vendor_Entity.Original_Manufacturer));
//sqlParamList.Add(new SqlParameter("@Inspection_Facility", productVendorInfo.Product_Vendor_Entity.Inspection_Facility));
//sqlParamList.Add(new SqlParameter("@Testing_Facility", productVendorInfo.Product_Vendor_Entity.Testing_Facility));
//if (productVendorInfo.Product_Vendor_Entity.Product_Vendor_Id == 0)
//{
// sqlParamList.Add(new SqlParameter("@CreatedBy", productVendorInfo.Product_Vendor_Entity.CreatedBy));
//}
//sqlParamList.Add(new SqlParameter("@UpdatedBy", productVendorInfo.Product_Vendor_Entity.UpdatedBy));
// if (productVendorInfo.Product_Vendor_Entity.Product_Vendor_Id != 0)
// {
// sqlParamList.Add(new SqlParameter("@Product_Vendor_Id", productVendorInfo.Product_Vendor_Entity.Product_Vendor_Id));
// }
// return sqlParamList;
//}
public void Update_Vendor(VendorInfo vendors)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Vendor(vendors), StoredProcedures.Update_Vendor_sp.ToString(), CommandType.StoredProcedure);
}
