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