public int SaveSubCatalogs(SubCatalogData objSubCatlogDO)
{
try
{
System.Data.SqlClient.SqlParameter[] obj = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@System_code", objSubCatlogDO.System_code),
new System.Data.SqlClient.SqlParameter("@SubSYSTEM_DESCRIPTION", objSubCatlogDO.SubSystem_Description),
new System.Data.SqlClient.SqlParameter("@SubSYSTEM_PARTICULARS", objSubCatlogDO.Subsystem_Particulars),
new System.Data.SqlClient.SqlParameter("@MAKER", objSubCatlogDO.Maker),
new System.Data.SqlClient.SqlParameter("@FUNCTIONS", objSubCatlogDO.Functions),
new System.Data.SqlClient.SqlParameter("@SET_INSTALED", objSubCatlogDO.Set_Installed),
new System.Data.SqlClient.SqlParameter("@MODULE_TYPE", objSubCatlogDO.Model_Type),
new System.Data.SqlClient.SqlParameter("@PREFERENCE_SUPPLIER", objSubCatlogDO.Preferred_Supplier),
new System.Data.SqlClient.SqlParameter("@Link", objSubCatlogDO.Link),
new System.Data.SqlClient.SqlParameter("@Created_By", objSubCatlogDO.CurrentUser),
new System.Data.SqlClient.SqlParameter("@ReturnID", DbType.Int32)
};
obj[10].Direction = ParameterDirection.ReturnValue;
int result = SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_SP_Ins_INV_SUBSYSTEM_LIBRARY]", obj);
Int32 ReqturnId = Convert.ToInt32(obj[10].Value);
return(ReqturnId);
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteSubCatelogs(SubCatalogData objSubCatlogDO)
{
try
{
System.Data.SqlClient.SqlParameter[] obj = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", objSubCatlogDO.SubCatalogId),
new System.Data.SqlClient.SqlParameter("@Deleted_By", objSubCatlogDO.CurrentUser)
};
return(SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_SP_del_SubSystems_Library]", obj));
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdateSubCatalogs(SubCatalogData objSubCatlogDO)
{
try
{
System.Data.SqlClient.SqlParameter[] obj = new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@ID", objSubCatlogDO.SubCatalogId),
new System.Data.SqlClient.SqlParameter("@SYSTEM_CODE", objSubCatlogDO.System_code),
new System.Data.SqlClient.SqlParameter("@SUBSYSTEM_DESCRIPTION", objSubCatlogDO.SubSystem_Description),
new System.Data.SqlClient.SqlParameter("@SUBSYSTEM_PARTICULARS", objSubCatlogDO.Subsystem_Particulars),
new System.Data.SqlClient.SqlParameter("@MAKER", objSubCatlogDO.Maker),
new System.Data.SqlClient.SqlParameter("@FUNCTIONS", objSubCatlogDO.Functions),
new System.Data.SqlClient.SqlParameter("@SET_INSTALED", objSubCatlogDO.Set_Installed),
new System.Data.SqlClient.SqlParameter("@MODULE_TYPE", objSubCatlogDO.Model_Type),
new System.Data.SqlClient.SqlParameter("@Link", objSubCatlogDO.Link),
new System.Data.SqlClient.SqlParameter("@Modified_By", objSubCatlogDO.CurrentUser)
};
return(SqlHelper.ExecuteNonQuery(_internalConnection, CommandType.StoredProcedure, "[PURC_SP_upd_INV_SUBSYSTEMS_LIBRARY]", obj));
}
catch (Exception ex)
{
throw ex;
}
}
public int SaveSubCatalogs(SubCatalogData objsubCatlogDO)
{
return(objSubCatalog.SaveSubCatalogs(objsubCatlogDO));
}
public int DeleteSubCatelogs(SubCatalogData objsubCatlogDO)
{
return(objSubCatalog.DeleteSubCatelogs(objsubCatlogDO));
}
public int EditSubCatalogs(SubCatalogData objsubCatlogDO)
{
return(objSubCatalog.UpdateSubCatalogs(objsubCatlogDO));
}
