public JsonResult SaveSchoolInfo(SchoolInfoVM scoolInfo)
{
var result = _schoolInfoBO.SaveSchoolInfo(scoolInfo);
return(Json(result, JsonRequestBehavior.AllowGet));
//return Json(null, JsonRequestBehavior.AllowGet);
}
public IActionResult Edit(SchoolInfoVM vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
vm.DoEdit(false);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
return(Ok(vm.Entity));
}
}
}
public int SaveSchoolInfo(SchoolInfoVM scoolInfo)
{
try
{
//To save values to User table
var data = _unitOfWork.Repository <Users>().ExecuteProcedure(" sp_users_INSERT(@UserName,@Password,@RoleId)",
new MySqlParameter("@UserName", MySqlDbType.VarChar)
{
Value = scoolInfo.UserName
},
new MySqlParameter("@Password", MySqlDbType.VarChar)
{
Value = scoolInfo.Password
},
new MySqlParameter("@RoleId", MySqlDbType.Int32)
{
Value = 2
});
var userId = _unitOfWork.Repository <Users>().GetAll().Where(f => f.UserName == scoolInfo.UserName).FirstOrDefault().UserId;
//To save values to school Info table
var result = _unitOfWork.Repository <SchoolInfo>().ExecuteProcedure("Proc_SetSchoolInfo(@SchoolName,@SchoolFirstColor,@SchoolSecondColor,@MastCot,@SchoolAddress,@City,@Zip,@ShippingAddress,@ShippingCity,@ShippingState,@ShippingZip,@Telephone,@AlternateTelephone,@Email,@Website,@ContactNumber,@ContactTitle,@ItemsRequiredFor,@ReceiveItemsForYear,@ItemsUsedFor,@AnnounceSponcerName,@PStateId,@UserId,@IsActive)",
new MySqlParameter("@SchoolName", MySqlDbType.VarChar)
{
Value = scoolInfo.SchoolName
},
new MySqlParameter("@SchoolFirstColor", MySqlDbType.VarChar)
{
Value = scoolInfo.SchoolFirstColor
},
new MySqlParameter("@SchoolSecondColor", MySqlDbType.VarChar)
{
Value = scoolInfo.SchoolSecondColor
},
new MySqlParameter("@MastCot", MySqlDbType.VarChar)
{
Value = scoolInfo.MastCot
},
new MySqlParameter("@SchoolAddress", MySqlDbType.VarChar)
{
Value = scoolInfo.SchoolAddress
},
new MySqlParameter("@City", MySqlDbType.VarChar)
{
Value = scoolInfo.City
},
new MySqlParameter("@Zip", MySqlDbType.VarChar)
{
Value = scoolInfo.Zip
},
new MySqlParameter("@ShippingAddress", MySqlDbType.VarChar)
{
Value = scoolInfo.ShippingAddress
},
new MySqlParameter("@ShippingCity", MySqlDbType.VarChar)
{
Value = scoolInfo.ShippingCity
},
new MySqlParameter("@ShippingState", MySqlDbType.Int32)
{
Value = scoolInfo.ShippingState
},
new MySqlParameter("@ShippingZip", MySqlDbType.VarChar)
{
Value = scoolInfo.ShippingZip
},
new MySqlParameter("@Telephone", MySqlDbType.VarChar)
{
Value = scoolInfo.Telephone
},
new MySqlParameter("@AlternateTelephone", MySqlDbType.VarChar)
{
Value = scoolInfo.AlternateTelephone
},
new MySqlParameter("@Email", MySqlDbType.VarChar)
{
Value = scoolInfo.Email
},
new MySqlParameter("@Website", MySqlDbType.VarChar)
{
Value = scoolInfo.Website
},
new MySqlParameter("@ContactNumber", MySqlDbType.VarChar)
{
Value = scoolInfo.ContactNumber
},
new MySqlParameter("@ContactTitle", MySqlDbType.VarChar)
{
Value = scoolInfo.ContactTitle
},
new MySqlParameter("@ItemsRequiredFor", MySqlDbType.VarChar)
{
Value = scoolInfo.ItemsRequiredFor
},
new MySqlParameter("@ReceiveItemsForYear", MySqlDbType.VarChar)
{
Value = scoolInfo.ReceiveItemsForYear
},
new MySqlParameter("@ItemsUsedFor", MySqlDbType.VarChar)
{
Value = scoolInfo.ItemsUsedFor
},
new MySqlParameter("@AnnounceSponcerName", MySqlDbType.Bit)
{
Value = scoolInfo.AnnounceSponcerName
},
new MySqlParameter("@PStateId", MySqlDbType.Int32)
{
Value = scoolInfo.StateId
},
new MySqlParameter("@UserId", MySqlDbType.Int32)
{
Value = userId
},
new MySqlParameter("@IsActive", MySqlDbType.Int32)
{
Value = 0
}
);
//var result = _unitOfWork.Repository<SchoolInfo>().ExecuteProcedure(" sp_test_INSERT(@TestName)",
// new MySqlParameter("@testname", MySqlDbType.VarChar) { Value = "Uma" });
return(result);
}
catch (Exception e)
{
return(0);
}
}
