public Tables.Supplier GetOne_Supplier(Guid id) { Params.spS_tblSupplier param = new Params.spS_tblSupplier(true); param.SetUpConnection(string.Empty); param.Param_Sup_GuidID = id; using (SPs.spS_tblSupplier sp = new SPs.spS_tblSupplier(true)) { System.Data.SqlClient.SqlDataReader sqlDataReader = null; sp.Execute(ref param, out sqlDataReader); param.Dispose(); if (sqlDataReader.Read()) { Tables.Supplier record = new Tables.Supplier(); record.Col_Sup_GuidID.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblSupplier.Resultset1.Fields.Column_Sup_GuidID.ColumnIndex); if (!record.Col_Sup_GuidID.UseNull) { record.Col_Sup_GuidID.Value = sqlDataReader.GetSqlGuid(SPs.spS_tblSupplier.Resultset1.Fields.Column_Sup_GuidID.ColumnIndex).Value; } record.Col_Sup_StrName.UseNull = sqlDataReader.IsDBNull(SPs.spS_tblSupplier.Resultset1.Fields.Column_Sup_StrName.ColumnIndex); if (!record.Col_Sup_StrName.UseNull) { record.Col_Sup_StrName.Value = sqlDataReader.GetSqlString(SPs.spS_tblSupplier.Resultset1.Fields.Column_Sup_StrName.ColumnIndex).Value; } sqlDataReader.Close(); sp.Connection.Close(); return(record); } else { sqlDataReader.Close(); sp.Connection.Close(); return(null); } } }
public Guid Add_Supplier(Tables.Supplier record) { Params.spI_tblSupplier param = new Params.spI_tblSupplier(true); param.SetUpConnection(string.Empty); if (record.Col_Sup_StrName == null || record.Col_Sup_StrName.UseNull) { param.Param_Sup_StrName = SqlString.Null; } else if (!record.Col_Sup_StrName.UseDefault) { param.Param_Sup_StrName = record.Col_Sup_StrName.Value; } using (SPs.spI_tblSupplier sp = new SPs.spI_tblSupplier(true)) { sp.Execute(ref param); Guid id = param.Param_Sup_GuidID.Value; param.Dispose(); return(id); } }
public void Edit_Supplier(Tables.Supplier record) { Params.spU_tblSupplier param = new Params.spU_tblSupplier(false); param.SetUpConnection(string.Empty); param.Param_Sup_GuidID = record.Col_Sup_GuidID.Value; if (record.Col_Sup_StrName == null || record.Col_Sup_StrName.UseNull) { param.Param_ConsiderNull_Sup_StrName = true; param.Param_Sup_StrName = SqlString.Null; } else if (!record.Col_Sup_StrName.UseDefault) { param.Param_Sup_StrName = record.Col_Sup_StrName.Value; } using (SPs.spU_tblSupplier sp = new SPs.spU_tblSupplier(true)) { sp.Execute(ref param); param.Dispose(); } }