public int InsUpdConsultant(EMConsultant objConsultant)
{
Hashtable htparams = new Hashtable
{
{ "@ConsultantId", objConsultant.ConsultantId },
{ "@KeyId", objConsultant.KeyId },
{ "@Name", objConsultant.Name },
{ "@GroupId", objConsultant.GroupId },
{ "@Division", objConsultant.Division },
{ "@Email", objConsultant.Email },
{ "@TelephoneNo", objConsultant.TelephoneNo },
{ "@CellNo", objConsultant.CellNo },
{ "@FaxNo", objConsultant.FaxNo },
{ "@ClientType", objConsultant.ClientType },
{ "@ClientStutus", objConsultant.ClientStutus },
{ "@CreatedBy", objConsultant.CreatedBy },
{ "@ClientAccCode", objConsultant.CompanyId },
{ "@ClientTypeAccCode", objConsultant.BranchId }
//{"@AccCode",objConsultant.AccCode}
};
int IsSuccess = ExecuteNonQuery("Consultants_InsertUpdate", htparams, "@return");
return(IsSuccess);
}
//CharteredAccounts
public int UpdChartAccounts(EMConsultant objConsultant)
{
Hashtable htparams = new Hashtable
{
{ "@ChartedAccName", objConsultant.ChartedAccName },
{ "@RefType", objConsultant.RefType },
{ "@RefId", objConsultant.RefId },
};
int IsSuccess = ExecuteNonQuery("CharteredAccounts_Update", htparams);
return(IsSuccess);
}
//CharteredAccounts
public int InsUpdChartAccounts(EMConsultant objConsultant)
{
Hashtable htparams = new Hashtable
{
{ "@ChartedAccId", objConsultant.ChartedAccId },
{ "@ChartedAccName", objConsultant.ChartedAccName },
{ "@ChartedMasterAccName", objConsultant.ChartedMasterAccName },
{ "@Type", objConsultant.Type },
{ "@AccCode", objConsultant.AccCode },
{ "@CompanyId", objConsultant.CompanyId },
{ "@BranchId", objConsultant.BranchId },
{ "@CreatedBy", objConsultant.CreatedBy },
{ "@DepartmentId", objConsultant.DepartmentId },
{ "@BaseCurrency", objConsultant.BaseCurrency },
{ "@TranCurrency", objConsultant.TranCurrency },
{ "@CategoryId", objConsultant.CategoryId },
{ "@RefType", objConsultant.RefType },
{ "@RefId", objConsultant.RefId },
};
int IsSuccess = ExecuteNonQuery("CharteredAccounts_Insert", htparams);
return(IsSuccess);
}
public int UpdateChartAccounts(EMConsultant objConsultant)
{
return(objDAConsultant.UpdChartAccounts(objConsultant));
}
public int InsUpdChartAccounts(EMConsultant objConsultant)
{
return(objDAConsultant.InsUpdChartAccounts(objConsultant));
}
public int InsUpdConsultant(EMConsultant objConsultant)
{
return(objDAConsultant.InsUpdConsultant(objConsultant));
}