public ActionResult AddEditAddressBook(AddressBookModel model)
{
if (ModelState.IsValid) //checking model is valid or not
{
DbData objDB = new DbData(); //calling class DBdata
string result = string.Empty;
if (model.ID.HasValue)
{
result = objDB.UpdateData(model); // passing Value to DBClass from model
}
else
{
result = objDB.InsertData(model);
}
ViewData["result"] = result;
ModelState.Clear(); //clearing model
return(RedirectToActionPermanent("ManageAddressBook"));
// return View();
}
else
{
// ModelState.AddModelError("", "Error in saving data");
return(View(new AddressBookModel()));
}
}
private bool UpdateDetail()
{
if (_sInsertDetail == string.Empty)
{
GenSqlString();
}
bool success = false;
foreach (DataRow drDetail in _lstDrCurrentDetails)
{
List <SqlField> tmp = new List <SqlField>();
List <string> paraNames = new List <string>();
List <object> paraValues = new List <object>();
List <SqlDbType> paraTypes = new List <SqlDbType>();
string sql = string.Empty;
bool isDeleteDt = false, isDelete = false, updateIdentity = false;
success = false;
switch (drDetail.RowState)
{
case DataRowState.Added:
if (_identityPkDt)
{
updateIdentity = true;
}
if (_identityPk)
{
string pk = _drTableMaster["Pk"].ToString();
if (drDetail.Table.Columns.Contains(pk))
{
drDetail[pk] = _drCurrentMaster[pk];
}
}
tmp = _vInsertDetail;
sql = _sInsertDetail;
break;
case DataRowState.Modified:
tmp = _vUpdateDetail;
sql = _sUpdateDetail;
break;
case DataRowState.Deleted:
tmp = _vDeleteDetail;
sql = _sDeleteDetail;
if (_drCurrentMaster.RowState == DataRowState.Deleted)
{
isDelete = true;
_drCurrentMaster.RejectChanges();
}
drDetail.RejectChanges();
isDeleteDt = true;
break;
}
if (sql != string.Empty)
{
foreach (SqlField sqlField in tmp)
{
string fieldName = sqlField.FieldName;
paraNames.Add(fieldName);
if (drDetail[fieldName].ToString() != string.Empty)
{
paraValues.Add(drDetail[fieldName]);
}
else
{
paraValues.Add(DBNull.Value);
}
paraTypes.Add(sqlField.DbType);
}
if (isDelete)
{
_drCurrentMaster.Delete();
}
if (isDeleteDt)
{
drDetail.Delete();
}
success = DbData.UpdateData(sql, paraNames.ToArray(), paraValues.ToArray(), paraTypes.ToArray());
if (success && updateIdentity)
{
string pk = _drTable["Pk"].ToString();
object o = DbData.GetValue("select @@identity");
if (o != null)
{
drDetail[pk] = o;
}
}
if (!success)
{
break;
}
}
else
{
success = true;
}
}
return(success);
}