public ApprovalTypeModel UpdateApprovalType(ApprovalTypeModel approvalTypeModel)
{
_approvalTypes.ReplaceOne(approvalType => approvalType.approvalCode.Equals(approvalTypeModel.approvalCode), approvalTypeModel);
ApprovalTypeModel tmpApprovalTypeModel = GetOneApprovalTypeByCode(approvalTypeModel.approvalCode);
return(tmpApprovalTypeModel);
}
static private OleDbCommand CreateOleDbCommand(ApprovalTypeModel approvalType, string commandText)
{
OleDbCommand command = new OleDbCommand(commandText);
command.Parameters.AddWithValue("@approvalCode", approvalType.approvalCode);
command.Parameters.AddWithValue("@approvalName", approvalType.approvalName);
return(command);
}
public static ApprovalTypeModel ToObject(DataRow reader)
{
ApprovalTypeModel approvalTypeModel = new ApprovalTypeModel();
approvalTypeModel.approvalCode = reader[0].ToString();
approvalTypeModel.approvalName = reader[1].ToString();
Debug.WriteLine("ApprovalTypeModel:" + approvalTypeModel.ToString());
return(approvalTypeModel);
}
public ApprovalTypeModel UpdateApprovalType(ApprovalTypeModel approvalTypeModel)
{
int i = -1;
using (OleDbCommand command = new OleDbCommand())
{
i = ExecuteNonQuery(ApprovalTypeStringsInner.UpdateApprovalType(approvalTypeModel));
}
return(GetOneApprovalTypeByCode(approvalTypeModel.approvalCode));
}
public ApprovalTypeModel AddApprovalType(ApprovalTypeModel approvalTypeModel)
{
if (_approvalTypes.Find <ApprovalTypeModel>(Builders <ApprovalTypeModel> .Filter.Eq(approvalType => approvalType.approvalCode, approvalTypeModel.approvalCode)).FirstOrDefault() == null)
{
_approvalTypes.InsertOne(approvalTypeModel);
}
ApprovalTypeModel tmpApprovalTypeModel = GetOneApprovalTypeByCode(approvalTypeModel.approvalCode);
return(tmpApprovalTypeModel);
}
static public MySqlCommand UpdateApprovalType(ApprovalTypeModel approvalTypeModel)
{
if (GlobalVariable.queryType == 0)
{
return(CreateSqlCommand(approvalTypeModel, queryApprovalTypesUpdate));
}
else
{
return(CreateSqlCommand(approvalTypeModel, procedureApprovalTypesUpdate));
}
}
public ApprovalTypeModel GetOneApprovalTypeByCode(string approvalCode)
{
DataTable dt = new DataTable();
ApprovalTypeModel approvalModelType = new ApprovalTypeModel();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(ApprovalTypeStringsInner.GetOneApprovalTypeByCode(approvalCode));
}
foreach (DataRow ms in dt.Rows)
{
approvalModelType = ApprovalTypeModel.ToObject(ms);
}
return(approvalModelType);
}
public List <ApprovalTypeModel> GetAllApprovalTypes()
{
DataTable dt = new DataTable();
List <ApprovalTypeModel> arrApprovalType = new List <ApprovalTypeModel>();
using (OleDbCommand command = new OleDbCommand())
{
dt = GetMultipleQuery(ApprovalTypeStringsInner.GetAllApprovalTypes());
}
foreach (DataRow ms in dt.Rows)
{
arrApprovalType.Add(ApprovalTypeModel.ToObject(ms));
}
return(arrApprovalType);
}
public ApprovalTypeModel UpdateApprovalType(ApprovalTypeModel approvalTypeModel)
{
DataTable dt = new DataTable();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(ApprovalTypeStringsSql.UpdateApprovalType(approvalTypeModel));
}
foreach (DataRow ms in dt.Rows)
{
approvalTypeModel = ApprovalTypeModel.ToObject(ms);
}
return(approvalTypeModel);
}
public ApprovalTypeModel GetOneApprovalTypeByCode(string approvalCode)
{
DataTable dt = new DataTable();
if (approvalCode.Equals(string.Empty) || approvalCode.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
ApprovalTypeModel approvalModelType = new ApprovalTypeModel();
using (SqlCommand command = new SqlCommand())
{
dt = GetMultipleQuery(ApprovalTypeStringsSql.GetOneApprovalTypeByCode(approvalCode));
}
foreach (DataRow ms in dt.Rows)
{
approvalModelType = ApprovalTypeModel.ToObject(ms);
}
return(approvalModelType);
}
static public OleDbCommand UpdateApprovalType(ApprovalTypeModel approvalTypeModel)
{
return(CreateOleDbCommand(approvalTypeModel, queryApprovalTypesUpdate));
}
static public OleDbCommand AddApprovalType(ApprovalTypeModel approvalTypeModel)
{
return(CreateOleDbCommand(approvalTypeModel, queryApprovalTypesPost));
}
