public int Insert_Industrial(IndustrialInfo industrialInfo)
{
int industrial_Master_Id = 0;
industrial_Master_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Industrial(industrialInfo), StoredProcedures.Insert_Industrial_Master_Sp.ToString(), CommandType.StoredProcedure));
return(industrial_Master_Id);
}
public int Insert_Material(MaterialInfo MaterialInfo)
{
int Material_Id = 0;
Material_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Material(MaterialInfo), StoredProcedures.Insert_Material_Sp.ToString(), CommandType.StoredProcedure));
return(Material_Id);
}
public int Insert_Consumable(ConsumableInfo consumable)
{
int consumable_Id = 0;
consumable_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Consumable(consumable), StoredProcedures.Insert_Consumable_sp.ToString(), CommandType.StoredProcedure));
return(consumable_Id);
}
public int Insert_Vendor(VendorInfo vendors)
{
int Vendor_Id = 0;
Vendor_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Vendor(vendors), StoredProcedures.Insert_Vendor_sp.ToString(), CommandType.StoredProcedure));
return(Vendor_Id);
}
public int Insert_Contact(ContactInfo contact)
{
int Contact_Id = 0;
Contact_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Contact(contact), StoredProcedures.Insert_Contact_sp.ToString(), CommandType.StoredProcedure));
return(Contact_Id);
}
public int Insert_Customer(CustomerInfo customer)
{
int Customer_Id = 0;
Customer_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Customer(customer), StoredProcedures.Insert_Customer_sp.ToString(), CommandType.StoredProcedure));
return(Customer_Id);
}
public int Insert_PArticle(PArticleInfo pArticle)
{
int pArticle_Id = 0;
pArticle_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_PArticle(pArticle), StoredProcedures.Insert_P_Article_Sp.ToString(), CommandType.StoredProcedure));
return(pArticle_Id);
}
public int Insert_Customer_Quality(CustomerQualityInfo customer_Quality)
{
int customer_Quality_Id = 0;
customer_Quality_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Customer_Quality(customer_Quality), StoredProcedures.Insert_Customer_Quality_Sp.ToString(), CommandType.StoredProcedure));
return(customer_Quality_Id);
}
public void Insert_User(UserInfo userInfo)
{
int UserId = 0;
UserId = Convert.ToInt32(sqlRepo.ExecuteScalerObj(SetValues_In_User(userInfo), StoredProcedures.Insert_User_Sp.ToString(), CommandType.StoredProcedure));
Insert_User_Role_Mapping(userInfo.Role_Ids, UserId);
}
public int Insert_YArticle(YArticleInfo yArticle)
{
int yArticle_Id = 0;
yArticle_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_YArticle(yArticle), StoredProcedures.Insert_Y_Article_sp.ToString(), CommandType.StoredProcedure));
return(yArticle_Id);
}
public int Insert_Quality(QualityInfo quality)
{
int Quality_Application_Id = 0;
Quality_Application_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Quality(quality), StoredProcedures.Insert_Quality_Sp.ToString(), CommandType.StoredProcedure));
return(Quality_Application_Id);
}
public int Insert_Complaint(ComplaintInfo complaintInfo)
{
int complaint_Id = 0;
complaint_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Complaint(complaintInfo), StoredProcedures.Insert_Complaint_Sp.ToString(), CommandType.StoredProcedure));
return(complaint_Id);
}
public int Insert_Work_Station(WorkStationInfo work_Station)
{
int work_Station_Id = 0;
work_Station_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Work_Station(work_Station), StoredProcedures.Insert_Work_Station_sp.ToString(), CommandType.StoredProcedure));
if (!string.IsNullOrEmpty(work_Station.Process_Ids))
{
Insert_Work_Station_Process(work_Station.Process_Ids, work_Station_Id);
}
return(work_Station_Id);
}
public int Insert_Role(RoleInfo RoleInfo)
{
int Role_Id = Convert.ToInt32(sqlRepo.ExecuteScalerObj(SetValues_In_Role(RoleInfo), StoredProcedures.Insert_Role_Sp.ToString(), CommandType.StoredProcedure));
return(Role_Id);
}
public long Insert_Attachment(AttachmentsInfo attachment)
{
long attachemnt_Id = Convert.ToInt64(sqlRepo.ExecuteScalerObj(Set_Values_In_Attachment(attachment), StoredProcedures.Insert_Attachment_Sp.ToString(), CommandType.StoredProcedure));
return(attachemnt_Id);
}
