public static MixERP.Net.Common.Models.Transactions.VerificationModel GetVerificationStatus(long transactionMasterId)
{
MixERP.Net.Common.Models.Transactions.VerificationModel model = new MixERP.Net.Common.Models.Transactions.VerificationModel();
string sql = "SELECT verification_status_id, office.get_user_name_by_user_id(verified_by_user_id) AS verified_by_user_name, verified_by_user_id, last_verified_on, verification_reason FROM transactions.transaction_master WHERE transaction_master_id=@TransactionMasterId;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
using (DataTable table = MixERP.Net.DatabaseLayer.DBFactory.DBOperations.GetDataTable(command))
{
if (table != null)
{
if (table.Rows.Count.Equals(1))
{
DataRow row = table.Rows[0];
model.Verification = MixERP.Net.Common.Conversion.TryCastShort(row["verification_status_id"]);
model.VerifierUserId = MixERP.Net.Common.Conversion.TryCastInteger(row["verified_by_user_id"]);
model.VerifierName = MixERP.Net.Common.Conversion.TryCastString(row["verified_by_user_name"]);
model.VerifiedDate = MixERP.Net.Common.Conversion.TryCastDate(row["last_verified_on"]);
model.VerificationReason = MixERP.Net.Common.Conversion.TryCastString(row["verification_reason"]);
}
}
}
}
return(model);
}
public static MixERP.Net.Common.Models.Transactions.VerificationModel GetVerificationStatus(long transactionMasterId)
{
MixERP.Net.Common.Models.Transactions.VerificationModel model = new MixERP.Net.Common.Models.Transactions.VerificationModel();
string sql = "SELECT verification_status_id, office.get_user_name_by_user_id(verified_by_user_id) AS verified_by_user_name, verified_by_user_id, last_verified_on, verification_reason FROM transactions.transaction_master WHERE transaction_master_id=@TransactionMasterId;";
using(NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
using(DataTable table = MixERP.Net.DatabaseLayer.DBFactory.DBOperations.GetDataTable(command))
{
if(table != null)
{
if(table.Rows.Count.Equals(1))
{
DataRow row = table.Rows[0];
model.Verification = MixERP.Net.Common.Conversion.TryCastShort(row["verification_status_id"]);
model.VerifierUserId = MixERP.Net.Common.Conversion.TryCastInteger(row["verified_by_user_id"]);
model.VerifierName = MixERP.Net.Common.Conversion.TryCastString(row["verified_by_user_name"]);
model.VerifiedDate = MixERP.Net.Common.Conversion.TryCastDate(row["last_verified_on"]);
model.VerificationReason = MixERP.Net.Common.Conversion.TryCastString(row["verification_reason"]);
}
}
}
}
return model;
}
