public async Task <Tuple <bool, string> > InsertStudentMapping(StudentMappingModel studentMappingModel)
{
Tuple <bool, string> result = null;
try
{
result = await _repo.InsertStudentMapping(studentMappingModel);
}
catch (Exception ex)
{
ErrorLog.Write(ex);
}
return(result);
}
public async Task <Tuple <bool, string> > InsertStudentMapping(StudentMappingModel studentMappingModel)
{
Tuple <bool, string> result = null;
int registerStatus = -1;
try
{
var parameters = new DynamicParameters();
using (SqlConnection cxn = new SqlConnection(_dcDb))
{
parameters.Add("@UserID", studentMappingModel.UserID, DbType.Int32);
parameters.Add("@StudentName", studentMappingModel.StudentName, DbType.String);
parameters.Add("@Gender", studentMappingModel.Gender, DbType.String);
parameters.Add("@Address1", studentMappingModel.Address1, DbType.String);
parameters.Add("@Address2", studentMappingModel.Address2, DbType.String);
parameters.Add("@City", studentMappingModel.City, DbType.String);
parameters.Add("@District", studentMappingModel.District, DbType.String);
parameters.Add("@State", studentMappingModel.State, DbType.String);
parameters.Add("@Country", studentMappingModel.Country, DbType.String);
parameters.Add("@Zipcode", studentMappingModel.Zipcode, DbType.String);
parameters.Add("@FeeMasterID", studentMappingModel.FeeMasterID, DbType.Int32);
parameters.Add("@GroupID", studentMappingModel.GroupID, DbType.Int32);
parameters.Add("@Fees", studentMappingModel.CourseFee, DbType.Decimal);
parameters.Add("@ApprovalStatusID", studentMappingModel.ApprovalStatusID, DbType.Int32);
parameters.Add("@TransferStatusID", studentMappingModel.TransferStatusID, DbType.Int32);
parameters.Add("@CreatedBy", UserID, DbType.Int32);
registerStatus = await cxn.ExecuteScalarAsync <int>("dbo.Insert_StudentMapping", parameters, commandType : CommandType.StoredProcedure);
if (registerStatus == 0)
{
result = Tuple.Create(true, "");
}
else
{
result = Tuple.Create(false, "Student mapping failed.Please try again.");
}
cxn.Close();
}
}
catch (Exception ex)
{
ErrorLog.Write(ex);
result = Tuple.Create(false, "Oops! Student mapping failed.Please try again.");
}
return(result);
}
