/// <summary>
/// UpdateMetadataInfo
/// </summary>
/// <param name="payload"></param>
/// <returns></returns>
public dynamic UpdateMetadataInfo(UpdateMetadataPayload payload)
{
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
sqlCon.Open();
foreach (var data in payload.metaDataItems)
{
string sql;
if ((data.value.GetType() == typeof(Int64) ||
data.value.GetType() == typeof(float) ||
data.value.GetType() == typeof(double) ||
data.value.GetType() == typeof(Int32) ||
data.value.GetType() == typeof(Int16) ||
data.value.GetType() == typeof(decimal)) && (data.value as string).ToLower() != "appname" && (data.value as string).ToLower() != "id")
{
sql = "update xrn_clone set " + data.name + " = " + (data.value == null) ? DBNull.Value : data.value + " where id=@id";
}
else if (data.value != null)
{
sql = "update xrn_clone set " + data.name + " = '" + data.value + "' where id=@id";
}
else
{
sql = "update xrn_clone set " + data.name + " = NULL' where id=@id";
}
SqlCommand reply;
reply = new SqlCommand(sql, sqlCon);
reply.CommandTimeout = 60;
reply.Parameters.AddWithValue("@id", payload.id);
reply.ExecuteNonQuery();
}
sqlCon.Close();
sqlCon.Dispose();
string userName;
if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268)
{
userName = "******";// HttpContext.Current.User.Identity.Name;
}
else
{
userName = HttpContext.Current.User.Identity.Name;
}
var guidelines = new GuidelinesLayer();
try
{
return(guidelines.GetGuidelines(0, null, payload.id, userName));
}
catch (InvalidOperationException)
{
return("Selected scorecard does not contain record with this ID");
}
catch (Exception)
{
return(new GuidelineScorecardInfo());
}
}
}
/// <summary>
/// RemoveSchoolDataInfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public dynamic RemoveSchoolDataInfo(SchoolDataItem info)
{
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
sqlCon.Open();
string sql;
SqlCommand reply;
sql = "delete from school_clone where id = @id";
reply = new SqlCommand(sql, sqlCon);
reply.CommandTimeout = 60;
reply.Parameters.AddWithValue("@id", info.id);
try
{
reply.ExecuteNonQuery();
}
catch (Exception ex)
{
}
sqlCon.Close();
sqlCon.Dispose();
string userName;
if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268)
{
userName = "******";// HttpContext.Current.User.Identity.Name;
}
else
{
userName = HttpContext.Current.User.Identity.Name;
}
var guidelines = new GuidelinesLayer();
try
{
return(guidelines.GetGuidelines(0, null, info.xccId, userName));
}
catch (InvalidOperationException)
{
return("Selected scorecard does not contain record with this ID");
}
catch (Exception)
{
return(new GuidelineScorecardInfo());
}
}
}
/// <summary>
/// SaveOtherDataInfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public dynamic SaveOtherDataInfo(List <OtherDataItem> info)
{
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
sqlCon.Open();
foreach (var data in info)
{
string sql;
SqlCommand reply;
if (data.id != null)
{
sql = "update other_clone set form_id=@formId,data_key=@dataKey,data_value=@dataValue,data_type=@dataType,school_name=@schoolName,label=@label"
+ "where id = @id";
}
else
{
sql = "insert into other_clone " +
"(id,form_id,data_key,data_value,data_type,xcc_id,school_name,label)" +
"values" +
"((select max(id)+1000000 from otherFormData ),@formId,@dataKey, @dataValue, @dataType,@xcc_id,@schoolName, @label )";
}
reply = new SqlCommand(sql, sqlCon);
reply.CommandTimeout = 60;
if (data.id != null)
{
reply.Parameters.AddWithValue("id", data.id);
}
else
{
reply.Parameters.AddWithValue("xcc_id", data.xccId);
}
reply.CommandType = CommandType.Text;
reply.Parameters.AddWithValue("@formId", (data.formId == null) ? DBNull.Value : (object)data.formId);
reply.Parameters.AddWithValue("@dataKey", (data.dataKey == null) ? DBNull.Value : (object)data.dataKey);
reply.Parameters.AddWithValue("@dataValue", data.dataValue == null ? DBNull.Value : (object)data.dataValue);
reply.Parameters.AddWithValue("@dataType", data.dataType == null ? DBNull.Value : (object)data.dataType);
reply.Parameters.AddWithValue("@schoolName", data.schoolName == null ? DBNull.Value : (object)data.schoolName);
reply.Parameters.AddWithValue("@label", data.label == null ? DBNull.Value : (object)data.label);
try
{
reply.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
sqlCon.Close();
sqlCon.Dispose();
var guidelines = new GuidelinesLayer();
string userName;
if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268)
{
userName = "******";// HttpContext.Current.User.Identity.Name;
}
else
{
userName = HttpContext.Current.User.Identity.Name;
}
try
{
return(guidelines.GetGuidelines(0, null, info.First().xccId, userName));
}
catch (InvalidOperationException)
{
return("Selected scorecard does not contain record with this ID");
}
catch (Exception)
{
return(new GuidelineScorecardInfo());
}
}
}
/// <summary>
/// SaveSchoolDataInfo
/// </summary>
/// <param name="payload"></param>
/// <returns></returns>
public dynamic SaveSchoolDataInfo(List <SchoolDataItem> payload)
{
using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
{
sqlCon.Open();
foreach (var data in payload)
{
string sql;
SqlCommand reply;
if (data.id != null)
{
sql = "update school_clone set School = @School, AOI1 = @AOI1,AOI2 = @AOI2,L1_SubjectName = @L1_SubjectName,L2_SubjectName = @L2_SubjectName,"
+ "Modality = @Modality,College = @College,DegreeOfInterest = @DegreeOfInterest,origin = @origin,tcpa = @tcpa where id = @id";
}
else
{
sql = "insert into school_clone " +
"(id,School,AOI1,AOI2,L1_SubjectName,L2_SubjectName,Modality,College,DegreeOfInterest,origin,tcpa,xcc_id)" +
"values" +
"((select max(id)+1000000 from School_X_Data ),@School,@AOI1, @AOI2, @L1_SubjectName, @L2_SubjectName, @Modality, @College, @DegreeOfInterest,@origin,@tcpa,@xcc_id)";
}
reply = new SqlCommand(sql, sqlCon);
reply.CommandTimeout = 60;
if (data.id != null)
{
reply.Parameters.AddWithValue("id", data.id);
}
else
{
reply.Parameters.AddWithValue("xcc_id", data.xccId);
}
reply.CommandType = CommandType.Text;
reply.Parameters.AddWithValue("@School", (data.school == null) ? DBNull.Value : (object)data.school);
reply.Parameters.AddWithValue("@AOI1", (data.AOI1 == null) ? DBNull.Value : (object)data.AOI1);
reply.Parameters.AddWithValue("@AOI2", data.AOI2 == null ? DBNull.Value : (object)data.AOI2);
reply.Parameters.AddWithValue("@L1_SubjectName", data.L1_SubjectName == null ? DBNull.Value : (object)data.L1_SubjectName);
reply.Parameters.AddWithValue("@L2_SubjectName", data.L2_SubjectName == null ? DBNull.Value : (object)data.L2_SubjectName);
reply.Parameters.AddWithValue("@Modality", data.Modality == null ? DBNull.Value : (object)data.Modality);
reply.Parameters.AddWithValue("@College", data.College == null ? DBNull.Value : (object)data.College);
reply.Parameters.AddWithValue("@DegreeOfInterest", data.DegreeOfInterest == null ? DBNull.Value : (object)data.DegreeOfInterest);
reply.Parameters.AddWithValue("@origin", data.origin == null ? DBNull.Value : (object)data.origin);
reply.Parameters.AddWithValue("@tcpa", data.tcpa == null ? DBNull.Value : (object)data.tcpa);
try
{
reply.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
sqlCon.Close();
sqlCon.Dispose();
var guidelines = new GuidelinesLayer();
string userName;
if (HttpContext.Current.Request.UrlReferrer.Host.Contains("localhost") && HttpContext.Current.Request.UrlReferrer.Port == 51268)
{
userName = "******";// HttpContext.Current.User.Identity.Name;
}
else
{
userName = HttpContext.Current.User.Identity.Name;
}
try
{
return(guidelines.GetGuidelines(0, null, payload[0].xccId, userName));
}
catch (InvalidOperationException)
{
return("Selected scorecard does not contain record with this ID");
}
catch (Exception)
{
return(new GuidelineScorecardInfo());
}
}
}