public void getType(ConferenceTypeModel conferenceType)
{
var result = _electriccastleContext.DictionaryConferenceType.FirstOrDefault(a => a.DictionaryConferenceTypeId == conferenceType.ConferenceTypeId);
result.ConferenceTypeCode = conferenceType.ConferenceTypeCode;
result.DictionaryConferenceTypeName = conferenceType.ConferenceTypeName;
_electriccastleContext.SaveChanges();
}
public void insertType(ConferenceTypeModel conferenceType)
{
var result = _electriccastleContext.DictionaryConferenceType.ToList();
var conferenceTypeModel = new DictionaryConferenceType {
DictionaryConferenceTypeId = _electriccastleContext.DictionaryConferenceType.Max(x => x.DictionaryConferenceTypeId) + 1, DictionaryConferenceTypeName = conferenceType.ConferenceTypeName, ConferenceTypeCode = conferenceType.ConferenceTypeCode
};
_electriccastleContext.DictionaryConferenceType.Add(conferenceTypeModel);
_electriccastleContext.SaveChanges();
}
public void insertType(ConferenceTypeModel conferenceType)
{
SqlCommand sqlCommand = _sqlConnection.CreateCommand();
sqlCommand.Connection = _sqlConnection;
//sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeId", conferenceType.ConferenceTypeId);
sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeName", conferenceType.ConferenceTypeName);
sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeCode", conferenceType.ConferenceTypeCode);
sqlCommand.CommandText = "insert into DictionaryConferenceType(DictionaryConferenceTypeId, DictionaryConferenceTypeName, ConferenceTypeCode) values ((select max(DictionaryConferenceTypeId) from DictionaryConferenceType)+1, @DictionaryConferenceTypeName, @DictionaryConferenceTypeCode)";
int rows = sqlCommand.ExecuteNonQuery();
}
public void getType(ConferenceTypeModel conferenceType)
{
SqlCommand sqlCommand = _sqlConnection.CreateCommand();
sqlCommand.Connection = _sqlConnection;
sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeId", conferenceType.ConferenceTypeId);
sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeName", conferenceType.ConferenceTypeName);
sqlCommand.Parameters.AddWithValue("@DictionaryConferenceTypeCode", conferenceType.ConferenceTypeCode);
sqlCommand.CommandText = "UPDATE DictionaryConferenceType set DictionaryConferenceTypeName=@DictionaryConferenceTypeName," +
"ConferenceTypeCode=@DictionaryConferenceTypeCode where DictionaryConferenceTypeId=@DictionaryConferenceTypeId ";
int rows = sqlCommand.ExecuteNonQuery();
}
private void btSaveType_Click(object sender, EventArgs e)
{
if (txtNameType.Text == string.Empty)
{
txtNameType.Focus();
errorProviderName.SetError(txtNameType, "Can't be empty");
}
else if (txtCodeType.Text == string.Empty)
{
txtCodeType.Focus();
errorProviderCode.SetError(txtCodeType, "Can't be empty");
}
if (txtNameType.Text != string.Empty && txtCodeType.Text != string.Empty)
{
int countType;
List <ConferenceTypeModel> listConferanceType = conferanceTypeRepository.getAllTypes();
countType = listConferanceType.Count;
ConferenceTypeModel type;
for (int i = 0; i < countType; i++)
{
type = listConferanceType.ElementAt(i);
if (ConferanceTypeId != null && ConferanceTypeId == i + 1)
{
type.ConferenceTypeName = txtNameType.Text;
type.ConferenceTypeCode = txtCodeType.Text;
conferanceTypeRepository.getType(type);
}
else
{
ConferenceTypeModel typeNew = new ConferenceTypeModel();
if (ConferanceTypeId == null)
{
typeNew.ConferenceTypeCode = " ";
typeNew.ConferenceTypeName = " ";
ConferanceTypeId = 0;
typeNew.ConferenceTypeName = txtNameType.Text;
typeNew.ConferenceTypeCode = txtCodeType.Text;
conferanceTypeRepository.insertType(typeNew);
}
}
}
this.Close();
}
}
public IActionResult Post(ConferenceTypeModel conferenceTypeModel)
{
conferenceType.insertType(conferenceTypeModel);
return(Ok(conferenceTypeModel));
}
public IActionResult Post(int Id, ConferenceTypeModel conferenceTypeModel)
{
conferenceTypeModel.ConferenceTypeId = Id;
conferenceType.getType(conferenceTypeModel);
return(Ok(conferenceType));
}
