/// <summary>
/// Returns the special fiels rules for the state.
/// </summary>
/// <param name="RuleType">Rule category type</param>
/// <param name="StateFIPS">sTATE</param>
/// <returns>IEnumerable<SpecialField></returns>
public static IEnumerable <ViewSpecialFieldsViewData> GetSpecialFieldRulesForState(FormType RuleType, string StateFIPS)
{
State StateValue = new State(StateFIPS);
IEnumerable <SpecialField> spFieldsRules = FileUploadDAL.GetSpecialUploadFieldsValues(RuleType, StateValue);
List <ViewSpecialFieldsViewData> spFieldsRulesData = new List <ViewSpecialFieldsViewData>();
foreach (SpecialField sf in spFieldsRules)
{
ViewSpecialFieldsViewData viewData = new ViewSpecialFieldsViewData();
viewData.Id = sf.Id;
viewData.Description = sf.Description;
viewData.EndDate = sf.EndDate.ToLongDateString();
viewData.FormType = sf.FormType.Description();
viewData.IsRequired = sf.IsRequired.ToString();
viewData.Name = sf.Name;
viewData.Ordinal = sf.Ordinal;
viewData.StartDate = sf.StartDate.ToLongDateString();
viewData.State = sf.State;
viewData.StateName = sf.State.StateName;
viewData.ValidationType = sf.ValidationType;
viewData.ValidationName = sf.ValidationType.Description();
//viewData.ValidationName
spFieldsRulesData.Add(viewData);
}
return(spFieldsRulesData);
}
/// <summary>
/// Initalize the view of data.
/// </summary>
private void OnViewInitialize()
{
ViewSpecialFieldsViewData Recs = SpecialFieldsBLL.GetSpecialFieldsView(int.Parse(SpecialFieldID));
dataSourceViewSpecialField.DataSource = Recs;
dataSourceViewSpecialField.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!ValidateForm())
{
return;
}
ViewSpecialFieldsViewData FieldValue = new ViewSpecialFieldsViewData();
FieldValue.Description = TxtDescription.Text;
FieldValue.EndDate = EndTextDate.Text;
FieldValue.StartDate = StartTextDate.Text;
if (lblFormType.Text == FormType.ClientContact.ToString())
{
FieldValue.FormType = FormType.ClientContact.ToString();
}
else
{
FieldValue.FormType = FormType.PublicMediaActivity.ToString();
}
FieldValue.IsRequired = rdIsRequired.SelectedItem.Text;
FieldValue.Name = TxtName.Text;
FieldValue.Id = int.Parse(SpecialFieldID);
string StateID = string.Empty;
ViewSpecialFieldsViewData FieldData = SpecialFieldsBLL.GetSpecialFieldsView(int.Parse(SpecialFieldID));
StateID = FieldData.State.Code;
FieldValue.State = new State(StateID);
FieldValue.ValidationName = ddlValidationType.SelectedItem.Text;
//Added by Lavanya
FieldValue.Range = txtValidationRange.Text;
//end
FieldValue.CreatedBy = AccountInfo.UserId;
FieldValue.Ordinal = -1;
try
{
SpecialFieldsBLL.AddUpdateSpecialField(FieldValue);
RouteController.RouteTo(RouteController.SpeciaFieldsView(int.Parse(SpecialFieldID)));
}
catch (ApplicationException exApp)
{
lblFeedBack.Text = exApp.Message;
lblFeedBack.Visible = true;
if (exApp.Message.Contains("The special field was created and assign available ordinal value"))
{
btnSave.Visible = false;
}
lblFeedBack.Visible = true;
}
}
//Lavanya: Added Range
private static ViewSpecialFieldsViewData GetSpecialFieldsViewData(SpecialField sf)
{
ViewSpecialFieldsViewData viewData = new ViewSpecialFieldsViewData();
viewData.Id = sf.Id;
viewData.Description = sf.Description;
viewData.EndDate = sf.EndDate.ToLongDateString();
viewData.FormType = sf.FormType.Description();
viewData.IsRequired = sf.IsRequired.ToString();
viewData.Name = sf.Name;
viewData.Ordinal = sf.Ordinal;
viewData.StartDate = sf.StartDate.ToLongDateString();
viewData.State = sf.State;
viewData.StateName = sf.State.StateName;
viewData.ValidationType = sf.ValidationType;
viewData.ValidationName = sf.ValidationType.Description();
viewData.CreatedDate = sf.CreatedDate.Value.ToLongDateString();
viewData.Range = sf.Range.Trim();
return(viewData);
}
public static IEnumerable <ViewSpecialFieldsViewData> GetSpecialFields(string StateFIPS, DateTime StartDate, DateTime EndDate, FormType DataForm)
{
List <ViewSpecialFieldsViewData> FoundSpecialFields = new List <ViewSpecialFieldsViewData>();
Database db = DatabaseFactory.CreateDatabase("DB_SHIP-NPR");
using (DbCommand dbCmd = db.GetStoredProcCommand(StoredProcNames.SpecialFields.GetSpecialFieldsByDate.Description()))
{
if (EndDate.Year != 1)
{
db.AddInParameter(dbCmd, "@EndDate", DbType.DateTime, EndDate);
}
db.AddInParameter(dbCmd, "@StartDate", DbType.DateTime, StartDate);
db.AddInParameter(dbCmd, "@StateFIPS", DbType.String, StateFIPS);
db.AddInParameter(dbCmd, "@FormType", DbType.Int32, (int)DataForm);
IDataReader rdrSpecialFields = null;
try
{
rdrSpecialFields = db.ExecuteReader(dbCmd);
while (rdrSpecialFields.Read())
{
if (!rdrSpecialFields.IsDBNull(0))
{
ViewSpecialFieldsViewData FoundField = new ViewSpecialFieldsViewData();
if (rdrSpecialFields["CreatedBy"] != null)
{
FoundField.CreatedBy = (int)rdrSpecialFields["CreatedBy"];
}
if (rdrSpecialFields["CreatedDate"] != null)
{
FoundField.CreatedDate = ((DateTime)rdrSpecialFields["CreatedDate"]).ToLongDateString();
}
if (!string.IsNullOrEmpty(rdrSpecialFields["Description"].ToString()))
{
FoundField.Description = (string)rdrSpecialFields["Description"];
}
FoundField.EndDate = ((DateTime)rdrSpecialFields["EndDate"]).ToLongDateString();
FoundField.FormType = ((FormType)int.Parse(rdrSpecialFields["FormType"].ToString())).ToString();
FoundField.Id = int.Parse(rdrSpecialFields["SpecialFieldId"].ToString());
if ((bool)rdrSpecialFields["IsRequired"])
{
FoundField.IsRequired = "Yes";
}
else
{
FoundField.IsRequired = "No";
}
FoundField.Name = rdrSpecialFields["Name"].ToString();
FoundField.StartDate = Convert.ToDateTime(rdrSpecialFields["StartDate"].ToString()).ToLongDateString();
FoundField.State = new State(rdrSpecialFields["StateFIPS"].ToString());
FoundField.ValidationType = (ValidationType)int.Parse(rdrSpecialFields["ValidationType"].ToString());
FoundField.Ordinal = int.Parse(rdrSpecialFields["Ordinal"].ToString());
FoundSpecialFields.Add(FoundField);
}
}
return(FoundSpecialFields);
}
finally
{
if (rdrSpecialFields != null)
{
rdrSpecialFields.Close();
rdrSpecialFields.Dispose();
}
}
}
}
public static int AddUpdateSpecialField(ViewSpecialFieldsViewData FieldData)
{
SpecialField FieldRec = new SpecialField();
FieldRec.Description = FieldData.Description;
FieldRec.StartDate = Convert.ToDateTime(FieldData.StartDate);
FieldRec.EndDate = Convert.ToDateTime(FieldData.EndDate);
if (FormType.ClientContact.ToString() == FieldData.FormType)
{
FieldRec.FormType = FormType.ClientContact;
}
if (FormType.PublicMediaActivity.ToString() == FieldData.FormType)
{
FieldRec.FormType = FormType.PublicMediaActivity;
}
FieldRec.IsRequired = false;
if (FieldData.IsRequired.ToUpper() == "YES")
{
FieldRec.IsRequired = true;
}
FieldRec.Name = FieldData.Name;
FieldRec.State = FieldData.State;
FieldRec.Ordinal = FieldData.Ordinal;
FieldRec.Id = FieldData.Id;
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.None.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.None;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.AlphaNumeric.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.AlphaNumeric;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Numeric.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Numeric;
}
//Added by Lavanya Maram: 06/27/2013
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Range.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Range;
}
if (FieldData.ValidationName == ShiptalkLogic.BusinessObjects.ValidationType.Option.ToString())
{
FieldRec.ValidationType = ShiptalkLogic.BusinessObjects.ValidationType.Option;
}
FieldRec.Range = FieldData.Range;
// end
FieldRec.CreatedBy = FieldData.CreatedBy;
try
{
return(SpecialFieldsDAL.AddSpecialField(FieldRec));
}
catch (SqlException exSql)
{
//2601 is thrown when the unique constraint is has been violated.
if (exSql.Number == 2601)
{
throw (new ApplicationException("Existing field has been defined for ordinal value " + FieldData.Ordinal.ToString(), exSql));
}
else
{
throw (new ApplicationException(exSql.Message, exSql));
}
}
}
private void OnInitialize()
{
ViewSpecialFieldsViewData FieldData = SpecialFieldsBLL.GetSpecialFieldsView(int.Parse(SpecialFieldID));
TxtDescription.Text = FieldData.Description;
TxtName.Text = FieldData.Name;
//check if the startdate falls after today's date
//then disbale the startdate
DateTime startdate;
if (System.DateTime.TryParse(FieldData.StartDate, out startdate) == false)
{
startdate = System.DateTime.MinValue;
}
if (startdate <= System.DateTime.Today)
{
StartTextDate.Enabled = false;
StartTextDate.CssClass = "";
ddlValidationType.Enabled = false;
rdIsRequired.Enabled = false;
}
if (FieldData.Ordinal < 11)
{
ddlFieldType.SelectedItem.Selected = false;
ddlFieldType.Items.FindByText("NATIONWIDE").Selected = true;
ddlFieldType.Enabled = false;
ddlFieldType_SelectedIndexChanged(this, null);
}
else
{
ddlFieldType.SelectedItem.Selected = false;
ddlFieldType.Items.FindByText("STATE").Selected = true;
ddlFieldType.Enabled = false;
ddlFieldType_SelectedIndexChanged(this, null);
}
ddlFieldType.Enabled = false;
DateTime StartDate = Convert.ToDateTime(FieldData.StartDate);
StartTextDate.Text = StartDate.ToString("MM/dd/yyyy");
DateTime EndDate = Convert.ToDateTime(FieldData.EndDate);
EndTextDate.Text = EndDate.ToString("MM/dd/yyyy");
ListItem SelectedValidationRule = ddlValidationType.Items.FindByText(FieldData.ValidationType.ToString());
SelectedValidationRule.Selected = true;
txtValidationRange.Text = FieldData.Range;
if (FieldData.FormType.Contains("Client Contact"))
{
lblFormType.Text = "ClientContact";
}
else
{
lblFormType.Text = "Public Media Activity";
}
lblState.Text = FieldData.StateName;
Session.Add("SPECIAL_FIELDS_EDIT_STATEFIPS", FieldData.State.Code);
if (FieldData.IsRequired.ToUpper() == "TRUE")
{
rdIsRequired.Items.FindByText("Yes").Selected = true;
}
else
{
rdIsRequired.Items.FindByText("No").Selected = true;
}
}
