/// <summary>
/// Adds the office.
/// </summary>
/// <param name="objComOffice">The object COM office.</param>
/// <param name="entryMode">The entry mode.</param>
/// <param name="officeId">The office identifier.</param>
public int AddOffice(ComOffice objComOffice, int entryMode, int officeId)
{
int i = 0;
if (entryMode == 0)//to insert office item
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_office.add_office");
db.AddInParameter(cmd, "v_office_nep_name", DbType.String, objComOffice.officeNepaliName);
db.AddInParameter(cmd, "v_office_eng_name", DbType.String, objComOffice.officeEnglishName);
db.AddInParameter(cmd, "v_office_parent_id", DbType.Int16, objComOffice.officeParentId);
db.AddInParameter(cmd, "v_office_type_id", DbType.Int16, objComOffice.officeTypeId);
/*db.AddInParameter(cmd, "v_ministry_id", DbType.Int16, objComOffice.ministryId);*/
db.AddInParameter(cmd, "v_vdc_mun_id", DbType.Int16, objComOffice.vdcMunId);
db.AddInParameter(cmd, "v_district_id", DbType.Int16, objComOffice.districtId);
db.AddInParameter(cmd, "v_isEnable", DbType.Int16, objComOffice.isEnable);
db.AddInParameter(cmd, "v_entered_by", DbType.String, null);
db.AddInParameter(cmd, "v_entered_date", DbType.String, DateTime.Today.ToString("dd-MM-yyyy"));
db.AddInParameter(cmd, "v_updated_by", DbType.String, null);
db.AddInParameter(cmd, "v_updated_date", DbType.String, DateTime.Today.ToString("dd-MM-yyyy"));
i = db.ExecuteNonQuery(cmd);
}
else // to update office item
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("pkg_office.update_office");
db.AddInParameter(cmd, "v_office_nep_name", DbType.String, objComOffice.officeNepaliName);
db.AddInParameter(cmd, "v_office_eng_name", DbType.String, objComOffice.officeEnglishName);
db.AddInParameter(cmd, "v_office_parent_id", DbType.Int16, objComOffice.officeParentId);
db.AddInParameter(cmd, "v_office_type_id", DbType.Int16, objComOffice.officeTypeId);
//db.AddInParameter(cmd, "v_ministry_id", DbType.Int16, objComOffice.ministryId);
db.AddInParameter(cmd, "v_vdc_mun_id", DbType.Int16, objComOffice.vdcMunId);
db.AddInParameter(cmd, "v_district_id", DbType.Int16, objComOffice.districtId);
db.AddInParameter(cmd, "v_isEnable", DbType.Int16, objComOffice.isEnable);
db.AddInParameter(cmd, "v_entered_by", DbType.String, null);
db.AddInParameter(cmd, "v_entered_date", DbType.String, DateTime.Today.ToString("dd-MM-yyyy"));
db.AddInParameter(cmd, "v_updated_by", DbType.String, null);
db.AddInParameter(cmd, "v_updated_date", DbType.String, DateTime.Today.ToString("dd-MM-yyyy"));
db.AddInParameter(cmd, "v_office_id", DbType.Int16, officeId);
i = db.ExecuteNonQuery(cmd);
}
return(i);
}
public int AddOffice(ComOffice objComOffice, int entryMode, int officeId)
{
Authentication();
return(objOfficeDal.AddOffice(objComOffice, entryMode, officeId));
}
