private void radButtonSave_Click(object sender, EventArgs e) { if (etConditionCode.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill condition code", "Information"); else if (etConditionName.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill condition name", "Information"); else { SqlConditionRepository sqlConditionRepository = new SqlConditionRepository(); SqlParameter[] param; if (wantToCreateCondition) { //Check city code has already exists ? param = SqlUtility.SetSqlParameter(new string[] { "condition_code" }, new object[] { etConditionCode.Text.Trim() }); if (sqlConditionRepository.CheckConditionCode(param, Guid.Empty, true)) { DialogResult dResult = MessageBox.Show(this, "City has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { param = SqlUtility.SetSqlParameter(new string[] { "condition_id", "condition_code", "condition_name", "deleted" }, new object[] { Guid.NewGuid(), etConditionCode.Text.Trim(), etConditionName.Text.Trim(), 0 }); if (sqlConditionRepository.ActivateCondition(param)) { MessageBox.Show(this, "Success Activate Condition", "Information"); radButtonClose.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show(this, "Cannot Activate Condition", "Information"); param = null; } return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (sqlConditionRepository.CheckConditionCode(param, Guid.Empty)) { MessageBox.Show(this, "Condition has already exists", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } param = null; param = SqlUtility.SetSqlParameter(new string[] { "condition_id", "condition_code", "condition_name", "deleted" }, new object[] { Guid.NewGuid(), etConditionCode.Text.Trim(), etConditionName.Text.Trim(), 0 }); if (sqlConditionRepository.CreateCondition(param)) { MessageBox.Show(this, "Success create condition", "Information"); radButtonClose.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot Create condition", "Information"); } } else { param = SqlUtility.SetSqlParameter(new string[] { "condition_code", "condition_name", "condition_id" }, new object[] { etConditionCode.Text.Trim(), etConditionName.Text.Trim(), condition.ID }); if (sqlConditionRepository.CheckConditionCode(param, this.condition.ID)) { MessageBox.Show(this, "condition has already exist. if it has already deleted. you must activate it with create new data", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sqlConditionRepository.EditCondition(param)) { MessageBox.Show(this, "Success Edit condition", "Information"); radButtonClose.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot Edit condition", "Information"); } } param = null; sqlConditionRepository = null; } }