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();
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 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);
}