public List <FormulariDetajet> FormulariDetajetFromJson(string detajetJson, int formulariId, string suksesiJson)
{
var rows = detajetJson.Split(';');
List <FormulariDetajet> detajet = new List <FormulariDetajet>();
if (rows != null)
{
for (int i = 0; i < rows.Length - 1; i++)
{
var recordSplitd = rows[i].Split(',');
FormulariDetajet temp = new FormulariDetajet()
{
FormulariId = formulariId,
OretEMbajtura = int.Parse(recordSplitd[2]),
OretEPlanifikuara = int.Parse(recordSplitd[1]),
};
foreach (SuksesiLendor suksesi in SuksesiLendorFromJson(suksesiJson))
{
if (int.Parse(recordSplitd[0]) == suksesi.LendaId)
{
temp.SuksesiLendors.Add(suksesi);
}
}
detajet.Add(temp);
}
}
return(detajet);
}
public static bool Create(FormulariDetajet formulariDetajet)
{
var conn = DBHelper.GetConnection();
try
{
var cmd = new SqlCommand("usp_FormulariDetaje_Insert", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FormulariId", formulariDetajet.FormulariId);
cmd.Parameters.AddWithValue("@OretEPlanifikuara", formulariDetajet.OretEPlanifikuara);
cmd.Parameters.AddWithValue("@OretEMbajtura", formulariDetajet.OretEMbajtura);
cmd.Parameters.Add("@prmId", SqlDbType.Int).Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
formulariDetajet.Id = Convert.ToInt32(cmd.Parameters["@prmId"].Value);
foreach (var item in formulariDetajet.SuksesiLendors)
{
item.FormulariDetajetId = formulariDetajet.Id;
DAL_SuksesiLendor.Create(item);
}
return(true);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
