public static int AddEditAgent(IfwdAgent Agent, int CompanyId) { string strExecution = "[fwd].[prcAddEditAgent]"; int Result = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@userID", Agent.CreatedBy); oDq.AddIntegerParam("@fk_CompanyID", CompanyId); oDq.AddBooleanParam("@isedit", Agent.Action); oDq.AddIntegerParam("@pk_AgentID", Agent.AgentID); oDq.AddIntegerParam("@fk_LineID", Agent.LinerID); oDq.AddIntegerParam("@fk_FPOD", Convert.ToInt32(Agent.FPODID)); oDq.AddVarcharParam("@AgentName", 50, Agent.AgentName); oDq.AddVarcharParam("@ContactPerson", 100, Agent.ContactPerson); oDq.AddVarcharParam("@AgentAddress", 300, Agent.AgentAddress); oDq.AddVarcharParam("@Fax", 100, Agent.FAX); oDq.AddVarcharParam("@Email", 100, Agent.email); oDq.AddVarcharParam("@Phone", 100, Agent.Phone); //oDq.AddDecimalParam("@WeightTo", 12, 3, Convert.ToDecimal(ImportHaulage.WeightTo)); //oDq.AddDecimalParam("@HaulageRate", 12, 2, Convert.ToDecimal(ImportHaulage.HaulageRate)); //oDq.AddBooleanParam("@HaulageStatus", ImportHaulage.HaulageStatus); oDq.AddIntegerParam("@RESULT", Result, QueryParameterDirection.Output); oDq.RunActionQuery(); Result = Convert.ToInt32(oDq.GetParaValue("@RESULT")); } return(Result); }
public static IfwdAgent GetAgent(int ID) { string strExecution = "[fwd].[prcGetAgentList]"; IfwdAgent oIH = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@AgentID", ID); oDq.AddVarcharParam("@SortExpression", 30, ""); oDq.AddVarcharParam("@SortDirection", 4, ""); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { oIH = new fwdAgentEntity(reader); } reader.Close(); } return(oIH); }
public int AddEditAgent(IfwdAgent Agent, int CompanyID) { return(fwdAgentDAL.AddEditAgent(Agent, CompanyID)); }