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