public int UpdateVdcMunById(VdcMun obj) { Authentication(); VdcMunManagementDAL objDal = new VdcMunManagementDAL(); return(objDal.UpdateVdcMunById(obj)); }
public int InsertVdcMun(VdcMun obj) { Authentication(); VdcMunManagementDAL objDal = new VdcMunManagementDAL(); return(objDal.InsertVdcMun(obj)); }
public int UpdateVdcMunById(VdcMun obj) { int i = 0; DbCommand cmd = null; cmd = db.GetStoredProcCommand("PR_UPDATE_VdcMun_BY_ID"); db.AddInParameter(cmd, "v_VDC_ID", DbType.Int32, obj.VdcMunId); db.AddInParameter(cmd, "v_VDC_MUN_CODE", DbType.String, obj.VdcMunCode); db.AddInParameter(cmd, "v_VDC_MUN_ENG_NAME", DbType.String, obj.VdcMunNameEng); db.AddInParameter(cmd, "v_VDC_MUN_NEP_NAME", DbType.String, obj.VdcMunNameNep); db.AddInParameter(cmd, "v_VDC_MUN_TYPE", DbType.String, obj.VdcMunType); db.AddInParameter(cmd, "v_DISTRICT", DbType.Int32, obj.District); db.AddInParameter(cmd, "v_ISENABLE", DbType.Int32, obj.IsEnable); i = db.ExecuteNonQuery(cmd); return(i); }
public int InsertVdcMun(VdcMun obj) { int i = 0; DbCommand cmd = null; cmd = db.GetStoredProcCommand("PR_INSERT_VDC_MUN"); db.AddInParameter(cmd, "v_VDC_MUN_CODE", DbType.String, obj.VdcMunCode); db.AddInParameter(cmd, "v_VDC_MUN_ENG_NAME", DbType.String, obj.VdcMunNameEng); db.AddInParameter(cmd, "v_VDC_MUN_NEP_NAME", DbType.String, obj.VdcMunNameNep); db.AddInParameter(cmd, "v_VDC_MUN_TYPE", DbType.String, obj.VdcMunType); db.AddInParameter(cmd, "v_DISTRICT", DbType.Int32, obj.District); db.AddInParameter(cmd, "v_ISENABLE", DbType.Int32, obj.IsEnable); db.AddInParameter(cmd, "v_ISLOCKED", DbType.Int32, obj.IsLocked); i = db.ExecuteNonQuery(cmd); return(i); }