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