private void AddPenaltyServices(Dictionary <string, Player> homePlayerMap, Dictionary <string, Player> awayPlayerMap,
IList <Jam> jams, IList <JamLineupModel> lineups, PenaltiesModel penalties)
{
Dictionary <int, Dictionary <int, IList <Models.BoxTimeModel> > > homePlayerBoxTimeMap = new Dictionary <int, Dictionary <int, IList <Models.BoxTimeModel> > >();
Dictionary <int, Dictionary <int, IList <Models.BoxTimeModel> > > awayPlayerBoxTimeMap = new Dictionary <int, Dictionary <int, IList <Models.BoxTimeModel> > >();
foreach (JamLineupModel jamLineup in lineups)
{
Jam jam = jams.First(j => j.IsFirstHalf == jamLineup.IsFirstHalf && j.JamNumber == jamLineup.JamNumber);
foreach (PlayerLineupModel playerLineup in jamLineup.HomeLineup)
{
if (playerLineup == null)
{
continue;
}
if (playerLineup.BoxTimes != null && playerLineup.BoxTimes.Any())
{
int playerID = homePlayerMap[playerLineup.PlayerNumber].ID;
if (!homePlayerBoxTimeMap.ContainsKey(playerID))
{
homePlayerBoxTimeMap[playerID] = new Dictionary <int, IList <Models.BoxTimeModel> >();
}
homePlayerBoxTimeMap[playerID][jam.ID] = playerLineup.BoxTimes;
}
}
foreach (PlayerLineupModel playerLineup in jamLineup.AwayLineup)
{
if (playerLineup.BoxTimes != null && playerLineup.BoxTimes.Any())
{
int playerID = awayPlayerMap[playerLineup.PlayerNumber].ID;
if (!awayPlayerBoxTimeMap.ContainsKey(playerID))
{
awayPlayerBoxTimeMap[playerID] = new Dictionary <int, IList <Models.BoxTimeModel> >();
}
awayPlayerBoxTimeMap[playerID][jam.ID] = playerLineup.BoxTimes;
}
}
}
Dictionary <int, PlayerPenaltiesModel> homePlayerPenalties = penalties.HomePlayerPenalties.ToDictionary(pp => homePlayerMap[pp.PlayerNumber].ID);
Dictionary <int, PlayerPenaltiesModel> awayPlayerPenalties = penalties.AwayPlayerPenalties.ToDictionary(pp => awayPlayerMap[pp.PlayerNumber].ID);
AddTeamPenaltyServices(jams, homePlayerMap, homePlayerBoxTimeMap, homePlayerPenalties);
AddTeamPenaltyServices(jams, awayPlayerMap, awayPlayerBoxTimeMap, awayPlayerPenalties);
}
public static object SavePenalty(PenaltiesModel pinfo, List <int> penaltyWCModel = null)
{
var rowsAffected = 0;
var response = new ResponseHandler();
try
{
object ValidateForm()
{
if (String.IsNullOrWhiteSpace(pinfo.penalty_code))
{
response.Status = 0;
response.Message = "Penalty code is required.";
return(response);
}
if (pinfo.penalty_type.ToLower().Equals("rs") && penaltyWCModel.Count < 1)
{
response.Status = 0;
response.Message = "Work collection should be added to a return submissioin penalty type.";
return(response);
}
if (string.IsNullOrWhiteSpace(pinfo.penalty_desc))
{
response.Status = 0;
response.Message = "Penalty description is required.";
return(response);
}
if (pinfo.ri_type_id == null || pinfo.ri_type_id == 0)
{
response.Status = 0;
response.Message = "Return institution type is required.";
return(response);
}
if (pinfo.penalty_type.ToLower().Equals("--choose one--") || pinfo.penalty_type == "")
{
response.Status = 0;
response.Message = "Penalty type is required.";
return(response);
}
if (string.IsNullOrWhiteSpace(pinfo.frequncy))
{
response.Status = 0;
response.Message = "Penalty frequency is required.";
return(response);
}
if (string.IsNullOrWhiteSpace(pinfo.penalty_freq_unit.ToString()))
{
response.Status = 0;
response.Message = "Penalty frequency unit is required.";
return(response);
}
if (string.IsNullOrWhiteSpace(pinfo.penalty_value.ToString()))
{
response.Status = 0;
response.Message = "Penalty value is required.";
return(response);
}
if (pinfo.start_validity_date < DateTime.Now)
{
response.Status = 0;
response.Message = "Penalty start validity date must be in the present or future date";
return(response);
}
return(response);
};
ValidateForm();
var _penalties = new Penalties();
if (pinfo.penalty_type == SharedConst.PENALTY_TYPE_RS)
{
Dictionary <int, string> _selectedWorkCollections = new Dictionary <int, string>();
foreach (var li in penaltyWCModel)
{
if (li != null)
{
_selectedWorkCollections.Add(li, li.ToString());
}
}
var _penaltyWcModel = new PenaltyWorkCollectionModel();
_penaltyWcModel.penalty_code = pinfo.penalty_code;
_penaltyWcModel.work_collection_id = _selectedWorkCollections;
_penaltyWcModel.created_date = DateTime.Now;
_penaltyWcModel.created_by = pinfo.created_by;
rowsAffected = _penalties.SavePenalty(pinfo, _penaltyWcModel);
}
else
{
rowsAffected = _penalties.SavePenalty(pinfo);
}
if (rowsAffected > 0)
{
response.Status = rowsAffected;
response.Message = $"Penalty records '{pinfo.penalty_code}' saved successfuly.";
return(response);
}
else
{
response.Status = rowsAffected;
response.Message = "Error while saving penalty details";
return(response);
}
}
catch (SqlException sqlEx)
{
LogUtitlity.LogToText(sqlEx.ToString());
if (sqlEx.Number == 2627)
{
response.Status = 0;
response.Message = "Penalty code already exists";
return(response);
}
}
catch (Exception ex)
{
LogUtitlity.LogToText(ex.ToString());
response.Status = 0;
response.Message = "Couldn't add penalty details";
return(response);
}
return(response);
}
protected void btnSavePenalty_Click(object sender, EventArgs e)
{
var rowsAffected = 0;
try
{
//ValidateForm();
_penaltiesModel = new PenaltiesModel();
_penaltiesModel.penalty_code = txtPenaltyCode.Value.Trim();
_penaltiesModel.penalty_desc = txtPenaltyDescription.Value.Trim();
_penaltiesModel.ri_type_id = Convert.ToInt32(cmbRiType.SelectedValue.Trim());
_penaltiesModel.penalty_type = cmbPenaltyType.SelectedValue.Trim();
_penaltiesModel.penalty_freq = cmbPenaltyFrequency.SelectedValue.Trim();
_penaltiesModel.penalty_freq_unit = Convert.ToInt32(txtPenaltyFreqUnit.Value);
_penaltiesModel.delivery_deadline_day =
(string.IsNullOrWhiteSpace(txtPenaltyDeadlineDay.Value)) ? (int?)null : Convert.ToInt32(txtPenaltyDeadlineDay.Value);
_penaltiesModel.delivery_deadline_hr =
(string.IsNullOrWhiteSpace(txtPenaltyDeadlineHour.Value)) ? (int?)null : Convert.ToInt32(txtPenaltyDeadlineHour.Value);
_penaltiesModel.delivery_deadline_min =
(String.IsNullOrWhiteSpace(txtPenaltyDeadlineMinute.Value)) ? (int?)null : Convert.ToInt32(txtPenaltyDeadlineMinute.Value);
//_penaltiesModel.min_limit_accepted = txtMinimumLimitsAccepted.Value;
//_penaltiesModel.max_limit_accepted = txtMaximumLimitsAccepted.Value;
_penaltiesModel.penalty_per_unit = (cmbPenaltyPerUnit.SelectedValue.Equals("0")) ? false : true;
_penaltiesModel.failed_penalty_value = txtFailedPenaltyValue.Value;
_penaltiesModel.penalty_value = Convert.ToDecimal(txtPenaltyValue.Value);
//_penaltiesModel.start_validity_date = Convert.ToDateTime(Convert.ToDateTime(txtStartValDate.Text).ToShortDateString());
_penaltiesModel.frequncy = cmbFrequency.SelectedValue;
if (txtEndValDate.Text == "" || txtEndValDate.Text == DateTime.MinValue.ToString())
{
_penaltiesModel.end_validity_date = _penaltiesModel.end_validity_date;
}
else
{
_penaltiesModel.end_validity_date = (DateTime?)null;
}
_penaltiesModel.created_date = DateTime.Now;
_penaltiesModel.created_by = base.currentUser;
if (this.hdRs.Value == SharedConst.PENALTY_TYPE_RS)
{
//foreach (ListItem li in cmbWorkCollection.Items)
//{
// if (li.Selected)
// {
// _selectedWorkCollections.Add(Convert.ToInt32(li.Value), li.Text);
// }
//}
//_penaltyWcModel = new PenaltyWorkCollectionModel();
//_penaltyWcModel.penalty_code = this.txtPenaltyCode.Value.Trim();
//_penaltyWcModel.work_collection_id = _selectedWorkCollections;
//_penaltyWcModel.created_date = DateTime.Now;
//_penaltyWcModel.created_by = base.currentUser;
//rowsAffected = _penalties.SavePenalty(_penaltiesModel, _penaltyWcModel);
}
else
{
rowsAffected = _penalties.SavePenalty(_penaltiesModel);
}
if (rowsAffected > 0)
{
divAlert.Visible = true;
divAlert.Attributes.Add("class", "alert alert-success alert-dismissible");
lblFrmError.Text = $"Penalty records '{this.txtPenaltyCode.Value}' saved successfuly, <a href='{Request.Url.ToString()}'>add</a> new penalty";
this.btnSave.Enabled = false;
}
else
{
divAlert.Visible = true;
lblFrmError.Text = "Error while saving penalty details";
}
}
catch (SqlException sqlEx)
{
Trace.Write(sqlEx.ToString());
divAlert.Visible = true;
lblFrmError.Text = sqlEx.ToString();
if (sqlEx.Number == 2627)
{
divAlert.Visible = true;
lblFrmError.Text = "Penalty code already exists";
}
else
{
divAlert.Visible = false;
}
}
catch (Exception ex)
{
LogUtitlity.LogToText(ex.ToString());
divAlert.Visible = true;
lblFrmError.Text = "Couldn't add penalty details" + ex.ToString();
}
}
private void AddPenaltyServices(Dictionary <string, Player> homePlayerMap, Dictionary <string, Player> awayPlayerMap,
IList <Jam> jams, IList <JamLineupModel> lineups, PenaltiesModel penalties)
{
Dictionary <int, PlayerPenaltiesModel> homePlayerPenalties = penalties.HomePlayerPenalties.ToDictionary(pp => homePlayerMap[pp.PlayerNumber].ID);
Dictionary <int, PlayerPenaltiesModel> awayPlayerPenalties = penalties.AwayPlayerPenalties.ToDictionary(pp => awayPlayerMap[pp.PlayerNumber].ID);
AddTeamPenalties(jams, homePlayerMap, homePlayerPenalties);
AddTeamPenalties(jams, awayPlayerMap, awayPlayerPenalties);
}