public DateSelect()
{
InitializeComponent();
DateTime d = new CommonFunctions().GetServerTime();
monthCalendar1.SelectionStart = d.AddMonths(-1);
monthCalendar2.SelectionStart = d;
}
public RequestFromModel SaveRequest(RequestFromModel RFM, string mode)
{
objDal = new DalFunctions();
objCon = new MyRealtyWeb.Data.Common.ClsConnection();
objCom = new CommonFunctions();
SqlParameter[] sqlParams = {
new SqlParameter("@Id",SqlDbType.Int){Value = 1},
new SqlParameter("@FName",SqlDbType.NVarChar){Value = RFM.FName},
new SqlParameter("@LName",SqlDbType.NVarChar){Value = RFM.LName},
new SqlParameter("@EmailAddress",SqlDbType.NVarChar){Value = RFM.EmailAddress},
new SqlParameter("@IsActive",SqlDbType.Bit){Value = false},
new SqlParameter("@IsDelete",SqlDbType.Bit){Value = false},
new SqlParameter("@UpdDt",SqlDbType.DateTime){Value = DateTime.Now},
new SqlParameter("@UpdBy",SqlDbType.NVarChar){Value = ""},
new SqlParameter("@Mode",SqlDbType.NVarChar){Value = mode},
};
CommandType type = CommandType.StoredProcedure;
SqlConnection con = objCon.myCon();
objState = new ClsConState.clsConnectionState(con);
RequestFromModel objModel = new RequestFromModel();
DataTable dt = new DataTable();
using (con)
{
dt = objDal.ExecuteReader(con, "Website_InsertRequest", type, sqlParams);
}
if (dt.Rows.Count > 0)
{
objModel.FName = Convert.ToString(objCom.HandleNull(dt.Rows[0]["FName"]));
objModel.LName = Convert.ToString(objCom.HandleNull(dt.Rows[0]["LName"]));
objModel.EmailAddress = Convert.ToString(objCom.HandleNull(dt.Rows[0]["EmailAddress"]));
}
return objModel;
}
public void BindLoanType()
{
clsComFun = new CommonFunctions();
try
{
clsComFun.LoanTypes(ddlLoanType);
}
catch { }
finally { clsComFun = null; }
}
public void BindNomini()
{
clsComFun = new CommonFunctions();
try
{
clsComFun.LoanNominee(ddlNomini);
}
catch { }
finally { clsComFun = null; }
}
private void LoadCombo()
{
try
{
LoadComboRef(ref ddlDivision, ALRD_DivisionInfoService.GetService().GetAll(new ALRD_DivisionInfoEntity()).ToList(), CommonFunctions.GetPropertyName((ALRD_DivisionInfoEntity x) => x.DESCRIPT), CommonFunctions.GetPropertyName((ALRD_DivisionInfoEntity x) => x.COMPID));
}
catch (Exception ex)
{
throw ex;
}
}
public override System.Xml.XmlDocument XmlSerialize()
{
System.Xml.XmlDocument document = base.XmlSerialize();
System.Xml.XmlNode propertiesNode = document.ChildNodes[1].ChildNodes[0];
#region Properties
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "MetricType", ((Int32)metricType).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "MetricTypeName", metricType.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "DataType", ((Int32)dataType).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "DataTypeName", dataType.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "MinimumValue", minimumValue.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "MaximumValue", maximumValue.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostDataSource", ((Int32)costDataSource).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostClaimDateType", ((Int32)costClaimDateType).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostDataSourceName", costDataSource.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostReportingPeriod", ((Int32)costReportingPeriod).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostReportingPeriodName", costReportingPeriod.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostReportingPeriodValue", costReportingPeriodValue.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostReportingPeriodQualifier", ((Int32)costReportingPeriodQualifier).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostReportingPeriodQualifierName", costReportingPeriodQualifier.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostWatermarkPeriod", ((Int32)costWatermarkPeriod).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostWatermarkPeriodName", costWatermarkPeriod.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostWatermarkPeriodValue", costWatermarkPeriodValue.ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostWatermarkPeriodQualifier", ((Int32)costWatermarkPeriodQualifier).ToString());
CommonFunctions.XmlDocumentAppendPropertyNode(document, propertiesNode, "CostWatermarkPeriodQualifierName", costWatermarkPeriodQualifier.ToString());
#endregion
// TODO: COST SERVICES EXPORT
#region Cost Services
//System.Xml.XmlElement CostServicesNode = CommonFunctions.XmlDocumentAppendPropertyNode (document, propertiesNode, "CostServices", String.Empty);
//foreach (WorkQueueTeam currentWorkQueueTeam in workTeams) {
// System.Xml.XmlElement workQueueTeamNode;
// workQueueTeamNode = document.CreateElement ("WorkQueueTeam");
// workQueueTeamNode.SetAttribute ("WorkTeamId", currentWorkQueueTeam.WorkTeamId.ToString ());
// workQueueTeamNode.SetAttribute ("WorkTeamName", application.CoreObjectGetNameById ("WorkTeam", currentWorkQueueTeam.WorkTeamId));
// workQueueTeamNode.SetAttribute ("Permission", ((Int32)currentWorkQueueTeam.Permission).ToString ());
// workQueueTeamNode.SetAttribute ("PermissionName", currentWorkQueueTeam.Permission.ToString ());
// workQueueTeamsNode.AppendChild (workQueueTeamNode);
//}
#endregion
return(document);
}
public response GetChildrens(string tableName)
{
return(CommonFunctions.GetChildrens(this, tableName));
}
/**
* Create Trial Asset
* @param ctx context
* @param user user
* @param entityType entity type
* @return asset or null if no product found
*/
public static MAsset GetTrial(Ctx ctx, MUser user, String entityType)
{
if (user == null)
{
_log.Warning("Cannot create Trial - No User");
return(null);
}
if (Utility.Util.IsEmpty(entityType))
{
_log.Warning("Cannot create Trial - No Entity Type");
return(null);
}
MProduct product = MProduct.GetTrial(ctx, entityType);
if (product == null)
{
_log.Warning("No Trial for Entity Type=" + entityType);
return(null);
}
//
DateTime now = Convert.ToDateTime(CommonFunctions.CurrentTimeMillis());
//
MAsset asset = new MAsset(ctx, 0, null);
asset.SetClientOrg(user);
asset.SetAssetServiceDate(now);
asset.SetIsOwned(false);
asset.SetIsTrialPhase(true);
//
MBPartner partner = new MBPartner(ctx, user.GetC_BPartner_ID(), null);
String documentNo = "Trial";
// Value
String value = partner.GetValue() + "_" + product.GetValue();
if (value.Length > 40 - documentNo.Length)
{
value = value.Substring(0, 40 - documentNo.Length) + documentNo;
}
asset.SetValue(value);
// Name MProduct.afterSave
String name = "Trial " + partner.GetName() + " - " + product.GetName();
if (name.Length > 60)
{
name = name.Substring(0, 60);
}
asset.SetName(name);
// Description
String description = product.GetDescription();
asset.SetDescription(description);
// User
asset.SetAD_User_ID(user.GetAD_User_ID());
asset.SetC_BPartner_ID(user.GetC_BPartner_ID());
// Product
asset.SetM_Product_ID(product.GetM_Product_ID());
asset.SetA_Asset_Group_ID(product.GetA_Asset_Group_ID());
asset.SetQty(new Decimal(product.GetSupportUnits()));
// Guarantee & Version
asset.SetGuaranteeDate(TimeUtil.AddDays(now, product.GetTrialPhaseDays()));
asset.SetVersionNo(product.GetVersionNo());
//
return(asset);
}
public response Insert()
{
response toReturn = Validare();
if (!toReturn.Status)
{
return(toReturn);
}
PropertyInfo[] props = this.GetType().GetProperties();
ArrayList _parameters = new ArrayList();
var col = CommonFunctions.table_columns(authenticatedUserId, connectionString, "plati");
foreach (PropertyInfo prop in props)
{
if (col != null && col.ToUpper().IndexOf(prop.Name.ToUpper()) > -1) // ca sa includem in Array-ul de parametri doar coloanele tabelei, nu si campurile externe si/sau alte proprietati
{
string propName = prop.Name;
string propType = prop.PropertyType.ToString();
object propValue = prop.GetValue(this, null);
propValue = propValue ?? DBNull.Value;
if (propType != null)
{
if (propName.ToUpper() != "ID") // il vom folosi doar la Edit!
{
_parameters.Add(new MySqlParameter(String.Format("_{0}", propName.ToUpper()), propValue));
}
}
}
}
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "PLATIsp_insert", _parameters.ToArray());
toReturn = da.ExecuteInsertQuery();
if (toReturn.Status)
{
this.ID = toReturn.InsertedId;
if (toReturn.Status)
{
try
{
Dosar d = new Dosar(authenticatedUserId, connectionString, Convert.ToInt32(this.ID_DOSAR));
d.UpdateCounterPlati(1);
}
catch (Exception exp) { LogWriter.Log(exp); }
}
if (toReturn.Status)
{
try
{
Dosar d = new Dosar(this.authenticatedUserId, this.connectionString, Convert.ToInt32(this.ID_DOSAR));
d.REZERVA_DAUNA -= this.SUMA;
d.GetNewStatus(false);
response r = d.Update();
if (!r.Status)
{
toReturn = r;
}
}
catch (Exception exp)
{
toReturn = new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
});
LogWriter.Log(exp);
}
}
}
return(toReturn);
}
public response ValidareColoane(string fieldValueCollection)
{
return(CommonFunctions.ValidareColoane(this, fieldValueCollection));
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
//CommonFunctions.Connection = new System.Data.SqlClient.SqlConnection();
this.RegionsSet = new Vacations.RegionsDataset();
this.StateProvincesSet = new Vacations.StateProvincesDataset();
this.AmenitiesSet = new Vacations.AmenitiesDataset();
this.CountriesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand4 = new System.Data.SqlClient.SqlCommand();
this.AmenitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand5 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand3 = new System.Data.SqlClient.SqlCommand();
this.RegionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand6 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand5 = new System.Data.SqlClient.SqlCommand();
this.AttractionsAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand4 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.CitiesSet = new Vacations.CitiesDataset();
this.CountriesSet = new Vacations.CountriesDataset();
this.StateProvincesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand3 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.AttractionsSet = new Vacations.AttractionsDataset();
this.CitiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlSelectCommand7 = new System.Data.SqlClient.SqlCommand();
this.PropertiesFullSet = new Vacations.PropertiesFullDataset();
this.PropertiesAdapter = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand6 = new System.Data.SqlClient.SqlCommand();
this.CountriesSet2 = new Vacations.CountriesDataset();
((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).BeginInit();
//
// CommonFunctions.Connection
//
//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
//"rsist security info=False;initial catalog=Vacations";
//
// RegionsSet
//
this.RegionsSet.DataSetName = "RegionsDataset";
this.RegionsSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// StateProvincesSet
//
this.StateProvincesSet.DataSetName = "StateProvincesDataset";
this.StateProvincesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// AmenitiesSet
//
this.AmenitiesSet.DataSetName = "AmenitiesDataset";
this.AmenitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CountriesAdapter
//
this.CountriesAdapter.SelectCommand = this.sqlSelectCommand4;
this.CountriesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// sqlSelectCommand4
//
this.sqlSelectCommand4.CommandText = "CountryDistinctList";
this.sqlSelectCommand4.CommandType = CommandType.StoredProcedure;
this.sqlSelectCommand4.Connection = CommonFunctions.GetConnection();
//
// AmenitiesAdapter
//
this.AmenitiesAdapter.InsertCommand = this.sqlInsertCommand5;
this.AmenitiesAdapter.SelectCommand = this.sqlSelectCommand3;
this.AmenitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Amenities", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Amenity", "Amenity")
})
});
//
// sqlInsertCommand5
//
this.sqlInsertCommand5.CommandText = "INSERT INTO Amenities(ID, Amenity) VALUES (@ID, @Amenity)";
this.sqlInsertCommand5.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
this.sqlInsertCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Amenity", System.Data.SqlDbType.NVarChar, 300, "Amenity"));
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "AmenityDistinctList";
this.sqlSelectCommand3.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand3.CommandType = CommandType.StoredProcedure;
//
// RegionsAdapter
//
this.RegionsAdapter.InsertCommand = this.sqlInsertCommand6;
this.RegionsAdapter.SelectCommand = this.sqlSelectCommand5;
this.RegionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Regions", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Region", "Region")
})
});
//
// sqlInsertCommand6
//
this.sqlInsertCommand6.CommandText = "INSERT INTO Regions(Region) VALUES (@Region)";
this.sqlInsertCommand6.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 300, "Region"));
//
// sqlSelectCommand5
//
this.sqlSelectCommand5.CommandText = "RegionDistinctList";
this.sqlSelectCommand5.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand5.CommandType = CommandType.StoredProcedure;
//
// AttractionsAdapter
//
this.AttractionsAdapter.InsertCommand = this.sqlInsertCommand4;
this.AttractionsAdapter.SelectCommand = this.sqlSelectCommand1;
this.AttractionsAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Attractions", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("Attraction", "Attraction")
})
});
//
// sqlInsertCommand4
//
this.sqlInsertCommand4.CommandText = "INSERT INTO Attractions(ID, Attraction) VALUES (@ID, @Attraction)";
this.sqlInsertCommand4.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, "ID"));
this.sqlInsertCommand4.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Attraction", System.Data.SqlDbType.NVarChar, 300, "Attraction"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "AttractionsDistinctList";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand1.CommandType = CommandType.StoredProcedure;
//
// CitiesSet
//
this.CitiesSet.DataSetName = "CitiesDataset";
this.CitiesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CountriesSet
//
this.CountriesSet.DataSetName = "CountriesDataset";
this.CountriesSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// StateProvincesAdapter
//
this.StateProvincesAdapter.InsertCommand = this.sqlInsertCommand3;
this.StateProvincesAdapter.SelectCommand = this.sqlSelectCommand2;
this.StateProvincesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince")
})
});
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.CommandText = "INSERT INTO StateProvinces(CountryID, StateProvince) VALUES (@CountryID, @StateProvince)";
this.sqlInsertCommand3.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CountryID", System.Data.SqlDbType.Int, 4, "CountryID"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvince", System.Data.SqlDbType.NVarChar, 300, "StateProvince"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "StateProvinceDistinctList";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.CommandType = CommandType.StoredProcedure;
//
// AttractionsSet
//
this.AttractionsSet.DataSetName = "AttractionsDataset";
this.AttractionsSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// CitiesAdapter
//
this.CitiesAdapter.InsertCommand = this.sqlInsertCommand1;
this.CitiesAdapter.SelectCommand = this.sqlSelectCommand7;
this.CitiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Cities", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("StateProvinceID", "StateProvinceID"),
new System.Data.Common.DataColumnMapping("City", "City")
})
});
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO Cities(StateProvinceID, City) VALUES (@StateProvinceID, @City)";
this.sqlInsertCommand1.Connection = CommonFunctions.GetConnection();
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StateProvinceID", System.Data.SqlDbType.Int, 4, "StateProvinceID"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 300, "City"));
//
// sqlSelectCommand7
//
this.sqlSelectCommand7.CommandText = @"SELECT DISTINCT Cities.ID, Cities.StateProvinceID, Cities.City FROM Cities INNER JOIN Properties ON Cities.ID=Properties.CityID WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) UNION SELECT -1, -1, ' Include All' ORDER BY City";
this.sqlSelectCommand7.Connection = CommonFunctions.GetConnection();
//
// PropertiesFullSet
//
this.PropertiesFullSet.DataSetName = "PropertiesFullDataset";
this.PropertiesFullSet.Locale = new System.Globalization.CultureInfo("en-US");
//
// PropertiesAdapter
//
this.PropertiesAdapter.SelectCommand = this.sqlSelectCommand6;
this.PropertiesAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Properties", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("MinimumNightlyRental", "MinimumNightlyRental"),
new System.Data.Common.DataColumnMapping("TaxIncluded", "TaxIncluded")
})
});
//
// sqlSelectCommand6
//
this.sqlSelectCommand6.CommandText = "TopThreePropertiesList";
this.sqlSelectCommand6.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand6.CommandType = CommandType.StoredProcedure;
//
// CountriesSet2
//
this.CountriesSet2.DataSetName = "CountriesDataset";
this.CountriesSet2.Locale = new System.Globalization.CultureInfo("en-US");
this.CountriesStates = new Vacations.CountriesStates();
this.GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
this.GetCountries = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.CountriesStates = new Vacations.CountriesStates();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.CountriesStates)).BeginInit();
//
// CommonFunctions.Connection
//
//CommonFunctions.Connection.ConnectionString = "workstation id=MAIN;packet size=4096;integrated security=SSPI;data source=MAIN;pe" +
//"rsist security info=False;initial catalog=Vacations";
//
// GetStateProvinces
//
this.GetStateProvinces.SelectCommand = this.sqlSelectCommand1;
this.GetStateProvinces.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "StateProvinces", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("CountryID", "CountryID"),
new System.Data.Common.DataColumnMapping("StateProvince", "StateProvince"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// GetCountries
//
this.GetCountries.SelectCommand = this.sqlSelectCommand2;
this.GetCountries.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Countries", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("RegionID", "RegionID"),
new System.Data.Common.DataColumnMapping("Country", "Country")
})
});
//
// sqlSelectCommand2
//
//this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER BY Country";
this.sqlSelectCommand2.CommandText = @"SELECT ID, RegionID, Country FROM Countries WHERE (RegionID = @RegionID) AND EXISTS (SELECT * FROM (Properties INNER JOIN Cities ON Properties.CityID = Cities.ID) INNER JOIN StateProvinces ON Cities.StateProvinceID = StateProvinces.ID WHERE (StateProvinces.CountryID = Countries.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) ) ORDER BY Country";
this.sqlSelectCommand2.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
this.sqlSelectCommand1.CommandText = @"SELECT StateProvinces.ID, StateProvinces.CountryID, StateProvinces.StateProvince, Countries.Country FROM StateProvinces INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID WHERE (Countries.RegionID = @RegionID) AND EXISTS (SELECT * FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID WHERE (Cities.StateProvinceID = StateProvinces.ID) AND (Properties.IfFinished = 1) AND (Properties.IfApproved = 1)) ORDER BY StateProvinces.StateProvince";
this.sqlSelectCommand1.Connection = CommonFunctions.GetConnection();
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RegionID", System.Data.SqlDbType.Int, 4, "RegionID"));
//
// CountriesStates
//
this.CountriesStates.DataSetName = "CountriesStates";
this.CountriesStates.Locale = new System.Globalization.CultureInfo("en-US");
//GetStateProvinces = new System.Data.SqlClient.SqlDataAdapter();
//System.Data.SqlClient.SqlDataAdapter GetCountries= new System.Data.SqlClient.SqlDataAdapter();
this.GetCountries.SelectCommand.Parameters["@RegionID"].Value = 6;
this.GetStateProvinces.SelectCommand.Parameters["@RegionID"].Value = 6;
////lock (CommonFunctions.Connection)
this.GetCountries.Fill(this.CountriesStates);
////lock (CommonFunctions.Connection)
this.GetStateProvinces.Fill(this.CountriesStates);
this.CountriesStates.Relations.Add("CountriesStates", this.CountriesStates.Tables["Countries"].Columns["ID"],
this.CountriesStates.Tables["StateProvinces"].Columns["CountryID"]);
//ltlAsia.Text = ds.Tables[0].Rows[1]["RegionTextValue"].ToString();
//ltlEurope.Text = ds.Tables[0].Rows[2]["RegionTextValue"].ToString();
//ltlNorthAmerica.Text = ds.Tables[0].Rows[3]["RegionTextValue"].ToString();
//ltlSouthAmerica.Text = ds.Tables[0].Rows[4]["RegionTextValue"].ToString();
//ltlOceania.Text = ds.Tables[0].Rows[5]["RegionTextValue"].ToString();
//ltlAsiaList.Text = GenerateCountryLinks("2");
//ltlOceaniaList.Text = GenerateCountryLinks("3");
//ltlSouthAmericaList.Text = GenerateCountryLinks("9");
//ltlEuropeList.Text = GenerateCountryLinks("6");
//ltlNorthAmericaList.Text = GenerateCountryLinks("8");
((System.ComponentModel.ISupportInitialize)(this.RegionsSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.StateProvincesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.AmenitiesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CitiesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.AttractionsSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.PropertiesFullSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.CountriesSet2)).EndInit();
}
/// <summary>
/// Date Modified: 16/03/2012
/// Modified By: Charlene Remotigue
/// (description) Use Global Code for parsing and casting
/// -------------------------------------------
/// Date Modified: 15/08/2012
/// Modified By: Josphine Gad
/// (description) Add different role's page
///----------------------------------------------
/// Date Modified: 16/08/2012
/// Modified By: Jefferson Bermundo
/// (description) Add HotelVendor page
/// Set UserBranchId upon Login
///----------------------------------------------
/// Date Modified: 23/10/2012
/// Modified By: Josephine Gad
/// (description) Change UserAccountBLL.GetUserPrimaryRole(sUser) to list
///----------------------------------------------
/// Date Modified: 27/Nov/2012
/// Modified By: Josephine Gad
/// (description) Add List<UserPrimaryDetails> instead of calling different proc in DB
///----------------------------------------------
/// Date Modified: 25/Apr/2013
/// Modified By: Josephine Gad
/// (description) Change Hotel Vendor's Page to HotelConfirmManifest.aspx Page
///----------------------------------------------
/// Date Modified: 7/May/2013
/// Modified By: Marco Abejar
/// (description) Change Crew Assist Page to HotelDashboardRoomType5.aspx Page
///----------------------------------------------
/// Date Modified: 11/Aug/2014
/// Modified By: Josephine Gad
/// (description) Add default page of Crew Medical Role
/// ===================================
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
//try
//{
AlertMessage("Logged already");
AlertMessage(GlobalCode.Field2String(User.Identity.Name));
//UserVendorBLL bll = new UserVendorBLL();
if (GlobalCode.Field2Int(UserVendorBLL.GetActiveUserVendor(User.Identity.Name)) == 0)
{
Session["ActiveUserVendor"] = 1;
Response.Redirect("Login.aspx");
//AlertMessage("There is no active contract connected in your account.");
}
if (User.Identity.Name == "")
{
Response.Redirect("Login.aspx", false);
}
MembershipUser mUser = Membership.GetUser(User.Identity.Name);
mUser.UnlockUser();
//if (mUser.CreationDate.Equals(mUser.LastPasswordChangedDate))
//{
// Response.Redirect("~/LoginReset.aspx", false);
//}
//else
{
string strLogDescription;
string strFunction;
string[] uRoles = Roles.GetRolesForUser(mUser.UserName);
if (uRoles[0] != "")
{
string sUser = mUser.UserName;
List <UserAccountList> userAccount = UserAccountBLL.GetUserInfoListByName(sUser);
Session["UserAccountList"] = userAccount;
List <UserPrimaryDetails> userDetails = (List <UserPrimaryDetails>)Session["UserPrimaryDetails"];
var vRole = (from a in userAccount
where a.bIsPrimary == true
select new
{
sRole = a.sRole
}).ToList(); //UserAccountBLL.GetUserPrimaryRole(sUser);
string PrimaryRole = vRole[0].sRole;
string strUserFName = userDetails[0].sFirstName + " as " + PrimaryRole;
//UserAccountBLL.GetUserFirstname(mUser.ToString()) + " as " + PrimaryRole;
DateTime dDateFrom = CommonFunctions.GetCurrentDateTime();
Session["UserName"] = sUser;
Session["UserRole"] = PrimaryRole;
Session["DateFrom"] = dDateFrom.ToString("MM/dd/yyyy");
//add UserBranchId Upon LogIn
Session["UserBranchID"] = userDetails[0].iBranchID; //UserAccountBLL.GetUserBranchId(sUser, PrimaryRole);
Session["BranchName"] = userDetails[0].sBranchName; //UserAccountBLL.GetUserBranchName(sUser, PrimaryRole);
Session["VendorID"] = userDetails[0].iVendorID; // UserAccountBLL.GetUserVendorId(sUser, PrimaryRole);
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
sUser, dDateFrom, dDateFrom.AddMinutes(90), false, PrimaryRole, FormsAuthentication.FormsCookiePath);
//Insert log audit trail (Gabriel Oquialda - 16/02/2012)
strLogDescription = "User logged as " + PrimaryRole + ".";
strFunction = "Page_Load";
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
BLL.AuditTrailBLL.InsertLogAuditTrail(0, "", strLogDescription, strFunction, Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, sUser);
if (PrimaryRole == TravelMartVariable.RoleAdministrator)
{
Response.Redirect("~/HotelDashboardRoomType5.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleHotelSpecialist)
{
//Response.Redirect("~/HotelDashboardRoomType.aspx?ufn=" + strUserFName);
Response.Redirect("~/HotelDashboardRoomType5.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RolePortSpecialist)
{
Response.Redirect("~/PortAgent/PortAgentDashboardNew.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleMeetGreet)
{
Response.Redirect("~/MeetAndGreet/MeetAndGreet.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleCrewAdmin)
{
Response.Redirect("~/CrewAdmin/CrewAdmin.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleHotelVendor)
{
//Response.Redirect("~/Hotel/HotelVendor.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
Response.Redirect("~/Hotel/HotelConfirmManifest.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleSystemAnalyst)
{
Response.Redirect("~/SystemAnalyst/ExceptionPNR.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleFinance)
{
Response.Redirect("~/ManifestSearchFilterPage.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleImmigration)
{
Response.Redirect("~/Immigration/CrewVerification.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleCrewAssist)
{
Response.Redirect("~/CrewAssist/CrewAssist.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
//Response.Redirect("~/CrewAssist/CrewAssistNew.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleCrewAssistTeamLead)
{
Response.Redirect("~/CrewAssist/CrewAssist.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
//Response.Redirect("~/Medical/Medical.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleVehicleVendor)
{
Response.Redirect("~/Vehicle/VehicleManifestByVendor.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleCrewMedical)
{
Response.Redirect("~/ManifestSearchFilterPage.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleCrewMedical)
{
Response.Redirect("~/ManifestSearchFilterPage.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleDriver)
{
Response.Redirect("~/Vehicle/VehicleManifestByVendor.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
else if (PrimaryRole == TravelMartVariable.RoleGreeter)
{
Response.Redirect("~/Vehicle/VehicleManifestByVendor.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy"));
}
//else
//{
// Response.Redirect("~/Manifest.aspx?ufn=" + strUserFName + "&dt=" + DateTime.Now.ToString("MM/dd/yyyy")); //gelo
//}
}
else
{
Response.Redirect("~/Login.aspx", false);
}
}
//}
//catch (Exception ex)
//{
// ExceptionBLL.InsertException(ex.Message, "LoginProcess.aspx", CommonFunctions.GetCurrentDateTime(), Session["UserName"].ToString());
//}
}
private void GenerateReport()
{
_student.FullName = _student.GetFullName();
_student.FullAddress = _student.GetFullAddress();
List <Student> list = new List <Student>();
list.Add(_student);
DataTable dt1 = CommonFunctions.ToDataTable <Student>(list);
DataTable dt2 = new DataTable();
dt2.Columns.Add("col1");
dt2.Columns.Add("col2");
foreach (DataColumn col in dt1.Columns)
{
DataRow dr1 = dt2.NewRow();
dr1["col1"] = col.ColumnName;
dr1["col2"] = dt1.Rows[0][col.ColumnName].ToString();
dt2.Rows.Add(dr1);
}
// _student.FullName = _student.GetFullName();
// _student.FullAddress = _student.GetFullAddress();
// DataTable dt = new DataTable();
// dt.Columns.Add("col1");
// dt.Columns.Add("col2");
// dt.Columns.Add("col3");
// dt.Columns.Add("col4");
//// dt.Columns.Add("col5");
// DataRow dr = dt.NewRow();
// dr["col2"] = "Student Report";
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Student Full Name:";
// dr["col2"] = _student.FullName;
// dr["col3"] = "Gender:";
// dr["col4"] = _student.Gender;
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Date of Birth:";
// dr["col2"] = _student.DateOfBirth?.ToString("dd/MM/yyyy");
// dr["col3"] = "Ethnicity:";
// dr["col4"] = _student.Ethnicity;
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Admitted to Activity Centre:";
// dr["col2"] = _student.AdmittedToActivityCentre?.ToString("dd/MM/yyyy");
// dr["col3"] = "Place of Birth:";
// dr["col4"] = _student.PlaceOfBirth;
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Admitted to Residence:";
// dr["col2"] = _student.AdmittedToResidence?.ToString("dd/MM/yyyy");
// dr["col3"] = "NHI Number:";
// dr["col4"] = _student.NHINumber;
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Home Phonee:";
// dr["col2"] = _student.HomePhone;
// dr["col3"] = "Mobile Phone:";
// dr["col4"] = _student.MobilePhone;
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Full Address:";
// dr["col2"] = _student.FullAddress;
// dr = dt.NewRow();
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Doctor(s)";
// dt.Rows.Add(dr);
// foreach (Doctor doctor in _student.Doctors)
// {
// dr = dt.NewRow();
// dr["col1"] = doctor.FullName;
// dr["col2"] = doctor.GetFullAddress();
// dr["col3"] = doctor.Phone;
// dt.Rows.Add(dr);
// }
// dr = dt.NewRow();
// dt.Rows.Add(dr);
// dr = dt.NewRow();
// dr["col1"] = "Next of Kin(s)";
// dt.Rows.Add(dr);
// foreach (NextOfKin nextofkin in _student.NextOfKin)
// {
// dr = dt.NewRow();
// dr["col1"] = nextofkin.FullName;
// dr["col2"] = nextofkin.GetFullAddress();
// dr["col3"] = nextofkin.Phone;
// dr["col4"] = nextofkin.Relationship;
// dt.Rows.Add(dr);
// }
DataFile df = new DataFile();
df.IOFileInfo.FileFullPath = _jarvis.OutputFileLocation + _student.FullName + "_Student Report_" + _jarvis.FileIncrement + ".XLSX";
df.IOFileInfo.OutputDataSource = dt2;
df.IOFileInfo.CreateHeader = false;
df.IOFileInfo.WorkSheetName = _student.FullName;
DataAccessBase eda = new ExcelDataAccess(df.IOFileInfo);
//eda.ReportProgress += new EventHandler<DataAccessEventMessenger>(eda_ReportProgress);
eda.Save();
System.Diagnostics.Process.Start(df.IOFileInfo.FileFullPath);
}
public void WritePropertyXML()
{
string fileLocation = HttpContext.Current.Server.MapPath("Output") + "\\";
try
{
ClearXMLDirectory(fileLocation);
ArrayList skipList = new ArrayList();
GetPrimaryKeyFields(WrapperAppParams.TableName, ref skipList);
GetColumnType(WrapperAppParams.TableName, ref skipList);
string query = "select * from " + WrapperAppParams.TableName + " where ";
string[] pkFieldList = WrapperAppParams.FieldNames.Split(';');
string[] pkFieldValues = WrapperAppParams.FieldValues.Split(';');
for (int k = 0; k < pkFieldList.Length; k++)
{
query += " \"" + pkFieldList[k] + "\"='" + pkFieldValues[k] + "'";
if (k < pkFieldList.Length - 1)
{
query += " AND ";
}
}
NpgsqlConnection dbConnection = new NpgsqlConnection();
dbConnection.ConnectionString = CommonFunctions.GetWrapperConenctionString();
dbConnection.Open();
DataTable dtValues = GetDataTable(query, dbConnection);
XmlDocument xml = new XmlDocument();
XmlElement root = xml.CreateElement("CAD");
xml.AppendChild(root);
XmlComment comment = xml.CreateComment("config values");
root.AppendChild(comment);
XmlElement connectionString = xml.CreateElement("connectionString");
connectionString.InnerText = CommonFunctions.GetConnectionString();
root.AppendChild(connectionString);
XmlElement wrapperConnectionString = xml.CreateElement("wrapperConnectionString");
wrapperConnectionString.InnerText = CommonFunctions.GetWrapperConenctionString();
root.AppendChild(wrapperConnectionString);
XmlElement metaTable = xml.CreateElement("metaTable");
metaTable.InnerText = CommonFunctions.GetMetaTableName();
root.AppendChild(metaTable);
//XmlElement metaTableStorage = xml.CreateElement("metadataStorage");
//metaTableStorage.InnerText = CommonFunctions.GetMetaDataStorageName();
//root.AppendChild(metaTableStorage);
XmlElement activeDatabase = xml.CreateElement("activeDatabase");
activeDatabase.InnerText = CommonFunctions.GetActiveDatabaseName();
root.AppendChild(activeDatabase);
comment = xml.CreateComment("field-value pair below");
root.AppendChild(comment);
XmlElement group = xml.CreateElement("group");
group.InnerText = WrapperAppParams.GroupName;
root.AppendChild(group);
DataRow dtRow = dtValues.Rows[0];
foreach (DataColumn col in dtValues.Columns)
{
XmlElement field = xml.CreateElement("field");
XmlElement name = xml.CreateElement("name");
if (!skipList.Contains(col.ColumnName))
{
name.InnerText = col.ColumnName;
XmlElement value = xml.CreateElement("value");
if (col.DataType.Name == "DateTime")
{
string date = "";
try
{
date = Convert.ToDateTime(dtRow[col.ColumnName]).ToString("dd-MM-yyyy");
}
catch
{
}
finally
{
value.InnerText = date;
}
}
else
{
value.InnerText = dtRow[col.ColumnName].ToString();
}
field.AppendChild(name);
field.AppendChild(value);
root.AppendChild(field);
}
}
System.IO.StreamWriter sw = new System.IO.StreamWriter(fileLocation + WrapperAppParams.FileName, false);
sw.WriteLine(xml.InnerXml);
sw.Close();
dbConnection.Close();
dtValues.Dispose();
}
catch (Exception exp)
{
File.Delete(fileLocation + WrapperAppParams.FileName);
throw exp;
}
}
/// <summary>
///
/// </summary>
/// <param name="context"></param>
public override void UpdateUIControlContext(object context)
{
try
{
base.UpdateUIControlContext(context);
Parameter parameter = (Parameter)context;
switch (parameter.Name)
{
case RegisterUpdateUIMsg.DisabledReadCardButton:
this.btnReadCard.Enabled = false;
break;
case RegisterUpdateUIMsg.EnabledReadCardButton:
this.btnReadCard.Enabled = true;
break;
case RegisterUpdateUIMsg.EnabledRegisterButton:
this.btnReadCard.Enabled = true;
break;
case RegisterUpdateUIMsg.DisabledRegisterButton:
this.btnReadCard.Enabled = false;
break;
case RegisterUpdateUIMsg.DisabledPrintButton:
this.btnPrint.Enabled = false;
break;
case RegisterUpdateUIMsg.EnabledPrintButton:
this.btnPrint.Enabled = true;
break;
case RegisterUpdateUIMsg.DisabledClearButton:
this.btnClear.Enabled = false;
break;
case RegisterUpdateUIMsg.EnabledClearButton:
this.btnClear.Enabled = true;
break;
case RegisterUpdateUIMsg.SetPersonInfo:
SetPersonInfo(parameter.Object);
break;
case RegisterUpdateUIMsg.ReadCardSuccess:
this._statusEvent.Status = "101";
break;
case RegisterUpdateUIMsg.ReadCardFailure:
this._statusEvent.Status = "102";
break;
case RegisterUpdateUIMsg.SaveSuccess:
this._statusEvent.Status = "201";
this._statusEvent.Status = "300";
CreateAndStartThread(this._thread, ThreadSaveDiagnoseInfo);
break;
case RegisterUpdateUIMsg.SaveDiagnoseInfoSuccess:
this._statusEvent.Status = "301";
break;
case RegisterUpdateUIMsg.SaveDiagnoseInfoFailure:
this._statusEvent.Status = "302";
break;
case RegisterUpdateUIMsg.SaveFailure:
this._statusEvent.Status = "202";
break;
default:
break;
}
}
catch (Exception ex)
{
CommonFunctions.MsgError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRegister_Click(object sender, EventArgs e)
{
if (this.txtBox_serial_no.Text.Trim() == string.Empty)
{
CommonFunctions.MsgInfo("就医保存号不能为空！！！");
return;
}
try
{
this._inParameter = new InterfaceClass.HN.ZY.RegisterUpdate.InParameter();
if (!CheckAndSetValue())
{
return;
}
List <List <Parameter> > listListParameter = new List <List <Parameter> >();
listListParameter.Add(GetProperties <InterfaceClass.HN.ZY.RegisterUpdate.InParameter>(this._inParameter));
GetTextBoxText(this.groupBoxRegisterInfo, ref listListParameter);
foreach (List <Parameter> listParameter in listListParameter)
{
foreach (Parameter p in listParameter)
{
List <Parameter> listInParameterArributes = GetProperties <InterfaceClass.HN.ZY.RegisterUpdate.InParameter>(this._inParameter);
foreach (Parameter pInParameterAttribute in listInParameterArributes)
{
if (p.Name == pInParameterAttribute.Name)
{
this._inParameter.SetAttributeValue(p.Name, p.Value);
}
}
}
}
List <InterfaceClass.HN.ZY.SaveDiagnoseInfo.DiagnoseInfo> listDiagnose = new List <InterfaceClass.HN.ZY.SaveDiagnoseInfo.DiagnoseInfo>();
if (this.c1FlexGridDisease.Cols.Contains("诊断编号"))
{
for (int i = 1; i < this.c1FlexGridDisease.Rows.Count; i++)
{
string icd = this.c1FlexGridDisease.Rows[i]["诊断编号"].ToString().Trim();
string diagnose_code = this.cBox_diagnose_code.SelectedValue.ToString().Trim();
InterfaceClass.HN.ZY.SaveDiagnoseInfo.DiagnoseInfo diagnoseInfo = new InterfaceClass.HN.ZY.SaveDiagnoseInfo.DiagnoseInfo();
diagnoseInfo.SetAttributeValue("diagnose_sn", i.ToString());
diagnoseInfo.SetAttributeValue("diagnose_code", diagnose_code);
diagnoseInfo.SetAttributeValue("icd", icd);
listDiagnose.Add(diagnoseInfo);
}
}
this._listDiagnose = listDiagnose;
}
catch (Exception ex)
{
CommonFunctions.MsgError("入院保存生成参数失败，请联系管理员！！！");
return;
}
this._statusEvent.Status = "200";
this._inParameter.serial_no = this.txtBox_serial_no.Text.Trim();
CreateAndStartThread(this._thread, ThreadSave);
}
public response DeleteOrphanFile(string fileName)
{
bool toReturn = FileManager.DeleteOrphan(Path.Combine(CommonFunctions.GetScansFolder(), fileName));
return(new response(toReturn, "", toReturn, null, null));
}
/// <summary>
/// Create a LifestyleQuality from an XmlNode.
/// </summary>
/// <param name="objXmlLifestyleQuality">XmlNode to create the object from.</param>
/// <param name="objCharacter">Character object the LifestyleQuality will be added to.</param>
/// <param name="objParentLifestyle">Lifestyle object to which the LifestyleQuality will be added.</param>
/// <param name="objLifestyleQualitySource">Source of the LifestyleQuality.</param>
/// <param name="strExtra">Forced value for the LifestyleQuality's Extra string (also used by its bonus node).</param>
public void Create(XmlNode objXmlLifestyleQuality, Lifestyle objParentLifestyle, Character objCharacter,
QualitySource objLifestyleQualitySource, string strExtra = "")
{
ParentLifestyle = objParentLifestyle;
if (!objXmlLifestyleQuality.TryGetField("id", Guid.TryParse, out _guiSourceID))
{
Log.Warn(new object[] { "Missing id field for xmlnode", objXmlLifestyleQuality });
Utils.BreakIfDebug();
}
else
{
_objCachedMyXmlNode = null;
}
if (objXmlLifestyleQuality.TryGetStringFieldQuickly("name", ref _strName))
{
_objCachedMyXmlNode = null;
}
objXmlLifestyleQuality.TryGetInt32FieldQuickly("lp", ref _intLP);
objXmlLifestyleQuality.TryGetStringFieldQuickly("cost", ref _strCost);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("multiplier", ref _intMultiplier);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("multiplierbaseonly", ref _intBaseMultiplier);
if (objXmlLifestyleQuality.TryGetStringFieldQuickly("category", ref _strCategory))
{
Type = ConvertToLifestyleQualityType(_strCategory);
}
OriginSource = objLifestyleQualitySource;
objXmlLifestyleQuality.TryGetInt32FieldQuickly("areamaximum", ref _intAreaMaximum);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("comfortsmaximum", ref _intComfortMaximum);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("securitymaximum", ref _intSecurityMaximum);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("area", ref _intArea);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("comforts", ref _intComfort);
objXmlLifestyleQuality.TryGetInt32FieldQuickly("security", ref _intSecurity);
objXmlLifestyleQuality.TryGetBoolFieldQuickly("print", ref _blnPrint);
objXmlLifestyleQuality.TryGetBoolFieldQuickly("contributetolimit", ref _blnContributeToLP);
if (!objXmlLifestyleQuality.TryGetStringFieldQuickly("altnotes", ref _strNotes))
{
objXmlLifestyleQuality.TryGetStringFieldQuickly("notes", ref _strNotes);
}
objXmlLifestyleQuality.TryGetStringFieldQuickly("source", ref _strSource);
objXmlLifestyleQuality.TryGetStringFieldQuickly("page", ref _strPage);
var strAllowedFreeLifestyles = string.Empty;
if (objXmlLifestyleQuality.TryGetStringFieldQuickly("allowed", ref strAllowedFreeLifestyles))
{
_lstAllowedFreeLifestyles = strAllowedFreeLifestyles.Split(',', StringSplitOptions.RemoveEmptyEntries);
}
_strExtra = strExtra;
if (!string.IsNullOrEmpty(_strExtra))
{
var intParenthesesIndex = _strExtra.IndexOf('(');
if (intParenthesesIndex != -1)
{
_strExtra = intParenthesesIndex + 1 < strExtra.Length
? strExtra.Substring(intParenthesesIndex + 1).TrimEndOnce(')')
: string.Empty;
}
}
if (string.IsNullOrEmpty(Notes))
{
string strEnglishNameOnPage = Name;
string strNameOnPage = string.Empty;
// make sure we have something and not just an empty tag
if (objXmlLifestyleQuality.TryGetStringFieldQuickly("nameonpage", ref strNameOnPage) &&
!string.IsNullOrEmpty(strNameOnPage))
{
strEnglishNameOnPage = strNameOnPage;
}
string strGearNotes = CommonFunctions.GetTextFromPdf(Source + ' ' + Page, strEnglishNameOnPage);
if (string.IsNullOrEmpty(strGearNotes) && GlobalOptions.Language != GlobalOptions.DefaultLanguage)
{
string strTranslatedNameOnPage = CurrentDisplayName;
// don't check again it is not translated
if (strTranslatedNameOnPage != _strName)
{
// if we found <altnameonpage>, and is not empty and not the same as english we must use that instead
if (objXmlLifestyleQuality.TryGetStringFieldQuickly("altnameonpage", ref strNameOnPage) &&
!string.IsNullOrEmpty(strNameOnPage) && strNameOnPage != strEnglishNameOnPage)
{
strTranslatedNameOnPage = strNameOnPage;
}
Notes = CommonFunctions.GetTextFromPdf(Source + ' ' + DisplayPage(GlobalOptions.Language),
strTranslatedNameOnPage);
}
}
else
{
Notes = strGearNotes;
}
}
// If the item grants a bonus, pass the information to the Improvement Manager.
XmlNode xmlBonus = objXmlLifestyleQuality["bonus"];
if (xmlBonus != null)
{
var strOldForced = ImprovementManager.ForcedValue;
if (!string.IsNullOrEmpty(_strExtra))
{
ImprovementManager.ForcedValue = _strExtra;
}
if (!ImprovementManager.CreateImprovements(objCharacter, Improvement.ImprovementSource.Quality,
InternalId, xmlBonus, 1, DisplayNameShort(GlobalOptions.Language)))
{
_guiID = Guid.Empty;
ImprovementManager.ForcedValue = strOldForced;
return;
}
if (!string.IsNullOrEmpty(ImprovementManager.SelectedValue))
{
_strExtra = ImprovementManager.SelectedValue;
}
ImprovementManager.ForcedValue = strOldForced;
}
// Built-In Qualities appear as grey text to show that they cannot be removed.
if (objLifestyleQualitySource == QualitySource.BuiltIn)
{
Free = true;
}
}
/// <summary>
/// Date Created: 04/Feb/2015
/// Created By: Josephine Monteza
/// (description) Save the "ToBeAdded" column for Vendor's approval
/// -------------------------------------------------------
/// </summary>
private void SaveHotelForecast()
{
DataTable dt = null;
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dateOnly = GlobalCode.Field2DateTime(dateNow.ToString("MM/dd/yyyy"));
Label listLabelDate;
//HiddenField listHiddenFieldToAddDBL;
//HiddenField listHiddenFieldToAddSGL;
TextBox listTextBoxDBL;
TextBox listTextBoxSGL;
TextBox listTextBoxRemarks;
TextBox listTextBoxRoomToDropDBL;
TextBox listTextBoxRoomToDropSGL;
CheckBox listCheckBoxSelect;
int iCount = uolistviewHotelInfo.Items.Count;
int iHotelID = GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue);
DataColumn colBranchIDInt = new DataColumn("colBranchIDInt", typeof(Int64));
DataColumn colDate = new DataColumn("colDate", typeof(DateTime));
DataColumn colForecastDBLAdj = new DataColumn("colForecastDBLAdj", typeof(int));
DataColumn colForecastSGLAdj = new DataColumn("colForecastSGLAdj", typeof(int));
DataColumn colRemarksVarchar = new DataColumn("colRemarksVarchar", typeof(string));
DataColumn colRoomToDropDBL = new DataColumn("colRoomToDropDBL", typeof(int));
DataColumn colRoomToDropSGL = new DataColumn("colRoomToDropSGL", typeof(int));
dt = new DataTable();
dt.Columns.Add(colBranchIDInt);
dt.Columns.Add(colDate);
dt.Columns.Add(colForecastDBLAdj);
dt.Columns.Add(colForecastSGLAdj);
dt.Columns.Add(colRemarksVarchar);
dt.Columns.Add(colRoomToDropDBL);
dt.Columns.Add(colRoomToDropSGL);
DataRow r;
DateTime rowDate;
for (int i = 0; i < iCount; i++)
{
listLabelDate = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelDate");
rowDate = GlobalCode.Field2DateTime(listLabelDate.Text);
if (rowDate >= dateOnly)
{
listCheckBoxSelect = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxSelect");
if (listCheckBoxSelect.Checked)
{
//listHiddenFieldToAddDBL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddDBL");
//listHiddenFieldToAddSGL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddSGL");
listTextBoxDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxDBLAdj");
listTextBoxSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxSGLAdj");
listTextBoxRemarks = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRemarks");
listTextBoxRoomToDropDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropDBL");
listTextBoxRoomToDropSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropSGL");
int iToAddDBLAdj = GlobalCode.Field2Int(listTextBoxDBL.Text);
int iToAddSGLAdj = GlobalCode.Field2Int(listTextBoxSGL.Text);
int iRoomToDropDBL = GlobalCode.Field2Int(listTextBoxRoomToDropDBL.Text);
int iRoomToDropSGL = GlobalCode.Field2Int(listTextBoxRoomToDropSGL.Text);
r = dt.NewRow();
r["colBranchIDInt"] = iHotelID;
r["colDate"] = rowDate;
r["colForecastDBLAdj"] = iToAddDBLAdj;
r["colForecastSGLAdj"] = iToAddSGLAdj;
r["colRemarksVarchar"] = listTextBoxRemarks.Text;
r["colRoomToDropDBL"] = iRoomToDropDBL;
r["colRoomToDropSGL"] = iRoomToDropSGL;
dt.Rows.Add(r);
}
}
}
if (dt.Rows.Count > 0)
{
BLL.UpdateForecastManifest(GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue),
uoHiddenFieldUser.Value, "Adjust Forecast", "SaveHotelForecast",
Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt);
GetSFHotelTravelDetails();
AlertMessage("Record successfully saved!");
}
else
{
AlertMessage("No record changed!");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
internal static void FormLoad(ref MenuEvent oMenuEvent, SAPbobsCOM.Company sbo_company, ref Application sbo_application, out bool bBubbleEvent, string sessionId)
{
bBubbleEvent = true;
FormCreationParams FormCreationPackage;
Form oForm = null;
if (oMenuEvent.BeforeAction)
{
FormCreationPackage = (FormCreationParams)sbo_application.CreateObject(BoCreatableObjectType.cot_FormCreationParams);
try
{
if (string.IsNullOrEmpty(sessionId))
{
sessionId = sbo_application.Company.GetServiceLayerConnectionContext(ServiceLayer.Address);
}
string contenidoArchivo = Properties.Resources.ResourceManager.GetString(pluginForm.FormType);
XmlDocument xmlFormulario = new XmlDocument();
xmlFormulario.LoadXml(contenidoArchivo);
FormCreationPackage.XmlData = xmlFormulario.InnerXml;
FormCreationPackage.UniqueID = pluginForm.FormType + CommonFunctions.Random().ToString();
oForm = sbo_application.Forms.AddEx(FormCreationPackage);
FormCreationPackage.UniqueID = "AsignaLote" + CommonFunctions.Random().ToString();
oForm = sbo_application.Forms.AddEx(FormCreationPackage);
DBDataSource dbData = oForm.DataSources.DBDataSources.Add("OBTN");
Matrix oMatrix = (Matrix)oForm.Items.Item(pluginForm.MatrixLote.Uid).Specific;
oMatrix.Item.Enabled = false;
Column oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_ItemCode.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_ItemCode.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_itemName.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_itemName.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_SysNumber.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_SysNumber.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_DistNumber.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_DistNumber.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_MnfSerial.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_MnfSerial.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_InDate.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_InDate.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_Status.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_Status.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_Quantity.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_Quantity.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_Balance.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_Balance.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_U_FRU_Variedad.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_U_FRU_Variedad.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_U_FRU_Tipo.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_U_FRU_Tipo.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_U_FRU_Calibre.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_U_FRU_Calibre.dbField);
oCol.Editable = false;
oCol = oMatrix.Columns.Item(pluginForm.MatrixLote.Colums.Col_U_FRU_Destino.Uid);
oCol.DataBind.SetBound(true, "OBTN", pluginForm.MatrixLote.Colums.Col_U_FRU_Destino.dbField);
SAPbobsCOM.Recordset oRS = (SAPbobsCOM.Recordset)sbo_company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
string sSql = " SELECT T0.\"U_DFO_Valor\",T0.\"U_DFO_Descrip\" FROM \"@DFO_OPDFO\" T0 " +
"where T0.\"U_DFO_Tipo\" = 'DESTINOSUGERIDO' ";
oRS.DoQuery(sSql);
if (oRS.RecordCount != 0)
{
while (!oRS.EoF)
{
string code = oRS.Fields.Item("U_DFO_Valor").Value.ToString();
string name = oRS.Fields.Item("U_DFO_Descrip").Value.ToString();
oCol.ValidValues.Add(code, name);
oRS.MoveNext();
}
}
oCol.DisplayDesc = true;
oCol.Editable = true;
//oConditions = (SAPbouiCOM.Conditions)oApplication.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_Conditions);
//oCondition = oConditions.Add();
//oCondition.Alias = "your field that you need filtering";
//oCondition.Operation = SAPbouiCOM.BoConditionOperation.co_LESS_THAN; //Your condition
//oCondition.CondVal = "condition value";
////run your query in your table with your conditions
//oDBDS.Query(oConditions);
dbData.Query(null);
oMatrix.LoadFromDataSourceEx(true);
oForm.Visible = true;
}
catch
{
throw;
}
}
}
/// <summary>
/// Date Created: 07/Oct/2015
/// Created By: Josephine Monteza
/// (description) Save the Additional Room to Hotel Room Blocks by RCCL
/// -------------------------------------------------------
/// </summary>
private void ApproveHotelForecast()
{
DataTable dt = null;
try
{
HotelForecastBLL BLL = new HotelForecastBLL();
DateTime dateNow = CommonFunctions.GetCurrentDateTime();
DateTime dateOnly = GlobalCode.Field2DateTime(dateNow.ToString("MM/dd/yyyy"));
Label listLabelDate;
//HiddenField listHiddenFieldToAddDBL;
//HiddenField listHiddenFieldToAddSGL;
//TextBox listTextBoxDBL;
//TextBox listTextBoxSGL;
TextBox listTextBoxRoomToDropDBL;
TextBox listTextBoxRoomToDropSGL;
//TextBox listTextBoxRatePerDayMoneyDBL;
//TextBox listTextBoxRatePerDayMoneySGL;
//TextBox listTextBoxRoomRateTaxPercentage;
//CheckBox listCheckBoxTaxInclusive;
Label listLabelRoomApprovedSGL;
Label listLabelRoomApprovedDBL;
CheckBox listCheckBoxApprove;
HiddenField listHiddenFieldAction;
int iCount = uolistviewHotelInfo.Items.Count;
int iHotelID = GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue);
DataColumn colBranchIDInt = new DataColumn("colBranchIDInt", typeof(Int64));
DataColumn colDate = new DataColumn("colDate", typeof(DateTime));
DataColumn colToAddDBL = new DataColumn("colToAddDBL", typeof(int));
DataColumn colToAddSGL = new DataColumn("colToAddSGL", typeof(int));
DataColumn colAction = new DataColumn("colAction", typeof(string));
DataColumn colRoomToDropDBL = new DataColumn("colRoomToDropDBL", typeof(int));
DataColumn colRoomToDropSGL = new DataColumn("colRoomToDropSGL", typeof(int));
DataColumn colRatePerDayMoneySGL = new DataColumn("colRatePerDayMoneySGL", typeof(float));
DataColumn colRatePerDayMoneyDBL = new DataColumn("colRatePerDayMoneyDBL", typeof(float));
DataColumn colCurrencyIDInt = new DataColumn("colCurrencyIDInt", typeof(int));
DataColumn colRoomRateTaxPercentage = new DataColumn("colRoomRateTaxPercentage", typeof(float));
DataColumn colRoomRateIsTaxInclusive = new DataColumn("colRoomRateIsTaxInclusive", typeof(float));
dt = new DataTable();
dt.Columns.Add(colBranchIDInt);
dt.Columns.Add(colDate);
dt.Columns.Add(colToAddDBL);
dt.Columns.Add(colToAddSGL);
dt.Columns.Add(colAction);
dt.Columns.Add(colRoomToDropDBL);
dt.Columns.Add(colRoomToDropSGL);
dt.Columns.Add(colRatePerDayMoneySGL);
dt.Columns.Add(colRatePerDayMoneyDBL);
dt.Columns.Add(colCurrencyIDInt);
dt.Columns.Add(colRoomRateTaxPercentage);
dt.Columns.Add(colRoomRateIsTaxInclusive);
DataRow r;
DateTime rowDate;
//CheckBox lvuoCheckBoxSelect;
for (int i = 0; i < iCount; i++)
{
listCheckBoxApprove = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxApprove");
if (listCheckBoxApprove.Checked)
{
listHiddenFieldAction = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldAction");
listLabelDate = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelDate");
rowDate = GlobalCode.Field2DateTime(listLabelDate.Text);
if (rowDate >= dateOnly)
{
//listHiddenFieldToAddDBL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddDBL");
//listHiddenFieldToAddSGL = (HiddenField)uolistviewHotelInfo.Items[i].FindControl("uoHiddenFieldToAddSGL");
listLabelRoomApprovedDBL = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelRoomApprovedDBL");
listLabelRoomApprovedSGL = (Label)uolistviewHotelInfo.Items[i].FindControl("uoLabelRoomApprovedSGL");
//listTextBoxDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxToAddDBL");
//listTextBoxSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxToAddSGL");
listTextBoxRoomToDropDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropDBL");
listTextBoxRoomToDropSGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomToDropSGL");
//listTextBoxRatePerDayMoneyDBL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRatePerDayMoneyDBL");
//listTextBoxRatePerDayMoneySGL = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRatePerDayMoneySGL");
//listTextBoxRoomRateTaxPercentage = (TextBox)uolistviewHotelInfo.Items[i].FindControl("uoTextBoxRoomRateTaxPercentage"); ;
//listCheckBoxTaxInclusive = (CheckBox)uolistviewHotelInfo.Items[i].FindControl("uoCheckBoxTaxInclusive");
//int iToAddDBLOld = GlobalCode.Field2Int(listHiddenFieldToAddDBL.Value);
//int iToAddSGLOld = GlobalCode.Field2Int(listHiddenFieldToAddSGL.Value);
int iToAddDBLNew = GlobalCode.Field2Int(listLabelRoomApprovedDBL.Text);
int iToAddSGLNew = GlobalCode.Field2Int(listLabelRoomApprovedSGL.Text);
int iToDropDBL = GlobalCode.Field2Int(listTextBoxRoomToDropDBL.Text);
int iToDropSGL = GlobalCode.Field2Int(listTextBoxRoomToDropSGL.Text);
//float fRatePerDayMoneyDBL = GlobalCode.Field2Float(listTextBoxRatePerDayMoneyDBL.Text);
//float fRatePerDayMoneySGL = GlobalCode.Field2Float(listTextBoxRatePerDayMoneySGL.Text);
//int iCurrency = GlobalCode.Field2Int(uoHiddenFieldCurrency.Value);
//float fTaxPercent = GlobalCode.Field2Float(listTextBoxRoomRateTaxPercentage.Text);
//bool bIsTaxInclusiveSingle = listCheckBoxTaxInclusive.Checked;
//if (iToAddDBLOld != iToAddDBLNew ||
// iToAddSGLOld != iToAddSGLNew)
//{
r = dt.NewRow();
r["colBranchIDInt"] = iHotelID;
r["colDate"] = rowDate;
r["colToAddDBL"] = iToAddDBLNew;
r["colToAddSGL"] = iToAddSGLNew;
r["colAction"] = listHiddenFieldAction.Value;
r["colRoomToDropDBL"] = iToDropDBL;
r["colRoomToDropSGL"] = iToDropSGL;
//r["colRatePerDayMoneySGL"] = fRatePerDayMoneySGL;
//r["colRatePerDayMoneyDBL"] = fRatePerDayMoneyDBL;
//r["colCurrencyIDInt"] = iCurrency;
//r["colRoomRateTaxPercentage"] = fTaxPercent;
//r["colRoomRateIsTaxInclusive"] = bIsTaxInclusiveSingle;
dt.Rows.Add(r);
//}
}
}
}
if (dt.Rows.Count > 0)
{
BLL.ApproveForecastManifestByRCCL(GlobalCode.Field2Int(uoDropDownListHotel.SelectedValue),
uoHiddenFieldUser.Value, "Add Override Forecast by RCCl Approval", "ApproveHotelForecast",
Path.GetFileName(Request.Path),
CommonFunctions.GetDateTimeGMT(dateNow), DateTime.Now, dt);
GetSFHotelTravelDetails();
AlertMessage("Record successfully approved!");
}
else
{
AlertMessage("No record changed!");
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
public response Update(string fieldValueCollection)
{
response r = ValidareColoane(fieldValueCollection);
if (!r.Status)
{
return(r);
}
else
{
Dictionary <string, string> changes = Newtonsoft.Json.JsonConvert.DeserializeObject <Dictionary <string, string> >(fieldValueCollection, CommonFunctions.JsonDeserializerSettings);
foreach (string fieldName in changes.Keys)
{
PropertyInfo[] props = this.GetType().GetProperties();
foreach (PropertyInfo prop in props)
{
//var col = CommonFunctions.table_columns(authenticatedUserId, connectionString, "actions");
//if (col != null && col.ToUpper().IndexOf(prop.Name.ToUpper()) > -1 && fieldName.ToUpper() == prop.Name.ToUpper()) // ca sa includem in Array-ul de parametri doar coloanele tabelei, nu si campurile externe si/sau alte proprietati
if (fieldName.ToUpper() == prop.Name.ToUpper())
{
var tmpVal = prop.PropertyType.FullName.IndexOf("System.Nullable") > -1 && changes[fieldName] == null ? null : prop.PropertyType.FullName.IndexOf("System.String") > -1 ? changes[fieldName] : prop.PropertyType.FullName.IndexOf("System.DateTime") > -1 ? CommonFunctions.SwitchBackFormatedDate(changes[fieldName]) : ((prop.PropertyType.FullName.IndexOf("Double") > -1) ? CommonFunctions.BackDoubleValue(changes[fieldName]) : Newtonsoft.Json.JsonConvert.DeserializeObject(changes[fieldName], prop.PropertyType));
prop.SetValue(this, tmpVal);
break;
}
}
}
return(this.Update());
}
}
private void BestelScreen_SizeChanged(object sender, EventArgs e)
{
// Set panels to center of the Form
CommonFunctions.SetPanelDimensions(PMain, ClientSize);
}
public response HasChildren(string tableName, int childrenId)
{
return(CommonFunctions.HasChildren(authenticatedUserId, connectionString, this, "plati", tableName, childrenId));
}
private void HomeUserControl_Loaded(object sender, RoutedEventArgs e)
{
if (!CommonFunctions.CurrentPrincipal.IsInRole("Administrator"))
{
ButtonRestart.IsEnabled = false;
}
//if (!CommonFunctions.CurrentPrincipal.IsInRole("Administrator,Editor"))
// ButtonInputWizard.IsEnabled = false;
m_windowsServiceClient = CommonFunctions.GetWindowsServiceClient();
if (m_windowsServiceClient == null || m_windowsServiceClient.Helper.RemotingClient.CurrentState != ClientState.Connected)
{
ButtonRestart.IsEnabled = false;
}
else
{
m_windowsServiceClient.Helper.ReceivedServiceResponse += Helper_ReceivedServiceResponse;
CommonFunctions.SendCommandToService("Health -actionable");
CommonFunctions.SendCommandToService("Version -actionable");
CommonFunctions.SendCommandToService("Status -actionable");
CommonFunctions.SendCommandToService("Time -actionable");
m_eventHandlerRegistered = true;
}
m_refreshTimer = new DispatcherTimer();
m_refreshTimer.Interval = TimeSpan.FromSeconds(5);
m_refreshTimer.Tick += RefreshTimer_Tick;
m_refreshTimer.Start();
if (IntPtr.Size == 8)
{
TextBlockInstance.Text = "64-bit";
}
else
{
TextBlockInstance.Text = "32-bit";
}
TextBlockLocalTime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
Version appVersion = AssemblyInfo.EntryAssembly.Version;
TextBlockManagerVersion.Text = appVersion.Major + "." + appVersion.Minor + "." + appVersion.Build + ".0";
try
{
using (AdoDataConnection database = new AdoDataConnection(CommonFunctions.DefaultSettingsCategory))
{
TextBlockDatabaseType.Text = database.DatabaseType.ToString();
try
{
if (database.IsSqlite || database.IsJetEngine)
{
// Extract database file name from connection string for file centric databases
TextBlockDatabaseName.Text = FilePath.GetFileName(database.Connection.ConnectionString.ParseKeyValuePairs()["Data Source"]);
}
else if (database.IsOracle)
{
// Extract user name from connection string for Oracle databases
TextBlockDatabaseName.Text = database.Connection.ConnectionString.ParseKeyValuePairs()["User Id"];
}
else
{
TextBlockDatabaseName.Text = database.Connection.Database;
}
}
catch
{
// Fall back on database name if file anything fails
TextBlockDatabaseName.Text = database.Connection.Database;
}
}
}
catch
{
TextBlockDatabaseName.Text = "Not Avaliable";
}
try
{
using (UserInfo info = new UserInfo(CommonFunctions.CurrentUser))
{
if (info.Exists)
{
TextBlockUser.Text = info.LoginID;
}
else
{
TextBlockUser.Text = CommonFunctions.CurrentUser;
}
}
}
catch
{
TextBlockUser.Text = CommonFunctions.CurrentUser;
}
((HorizontalAxis)ChartPlotterDynamic.MainHorizontalAxis).LabelProvider.LabelStringFormat = "";
//Remove legend on the right.
Panel legendParent = (Panel)ChartPlotterDynamic.Legend.ContentGrid.Parent;
if (legendParent != null)
{
legendParent.Children.Remove(ChartPlotterDynamic.Legend.ContentGrid);
}
ChartPlotterDynamic.NewLegendVisible = false;
m_xAxisDataCollection = new int[m_numberOfPointsToPlot];
for (int i = 0; i < m_numberOfPointsToPlot; i++)
{
m_xAxisDataCollection[i] = i;
}
m_xAxisBindingCollection = new EnumerableDataSource <int>(m_xAxisDataCollection);
m_xAxisBindingCollection.SetXMapping(x => x);
ComboBoxDevice.ItemsSource = Device.GetLookupList(null);
if (ComboBoxDevice.Items.Count > 0)
{
ComboBoxDevice.SelectedIndex = 0;
}
}
public response GetChildren(string tableName, int childrenId)
{
return(CommonFunctions.GetChildren(this, tableName, childrenId));
}
public void Create(XmlNode charNode, int intValue, int intMinModifier = 0, int intMaxModifier = 0)
{
Timekeeper.Start("create_char_attrib");
foreach (CharacterAttrib objAttribute in AttributeList.Concat(SpecialAttributeList))
{
objAttribute.UnbindAttribute();
}
AttributeList.Clear();
SpecialAttributeList.Clear();
foreach (string strAttribute in AttributeStrings)
{
CharacterAttrib objAttribute = new CharacterAttrib(_objCharacter, strAttribute);
switch (CharacterAttrib.ConvertToAttributeCategory(objAttribute.Abbrev))
{
case CharacterAttrib.AttributeCategory.Special:
SpecialAttributeList.Add(objAttribute);
break;
case CharacterAttrib.AttributeCategory.Standard:
AttributeList.Add(objAttribute);
break;
}
}
_objCharacter.BOD.AssignLimits(CommonFunctions.ExpressionToString(charNode["bodmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["bodmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["bodaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.AGI.AssignLimits(CommonFunctions.ExpressionToString(charNode["agimin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["agimax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["agiaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.REA.AssignLimits(CommonFunctions.ExpressionToString(charNode["reamin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["reamax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["reaaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.STR.AssignLimits(CommonFunctions.ExpressionToString(charNode["strmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["strmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["straug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.CHA.AssignLimits(CommonFunctions.ExpressionToString(charNode["chamin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["chamax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["chaaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.INT.AssignLimits(CommonFunctions.ExpressionToString(charNode["intmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["intmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["intaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.LOG.AssignLimits(CommonFunctions.ExpressionToString(charNode["logmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["logmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["logaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.WIL.AssignLimits(CommonFunctions.ExpressionToString(charNode["wilmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["wilmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["wilaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.MAG.AssignLimits(CommonFunctions.ExpressionToString(charNode["magmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["magmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["magaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.RES.AssignLimits(CommonFunctions.ExpressionToString(charNode["resmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["resmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["resaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.EDG.AssignLimits(CommonFunctions.ExpressionToString(charNode["edgmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["edgmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["edgaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.DEP.AssignLimits(CommonFunctions.ExpressionToString(charNode["depmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["depmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["depaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.MAGAdept.AssignLimits(CommonFunctions.ExpressionToString(charNode["magmin"]?.InnerText, intValue, intMinModifier), CommonFunctions.ExpressionToString(charNode["magmax"]?.InnerText, intValue, intMaxModifier), CommonFunctions.ExpressionToString(charNode["magaug"]?.InnerText, intValue, intMaxModifier));
_objCharacter.ESS.AssignLimits(CommonFunctions.ExpressionToString(charNode["essmin"]?.InnerText, intValue, 0), CommonFunctions.ExpressionToString(charNode["essmax"]?.InnerText, intValue, 0), CommonFunctions.ExpressionToString(charNode["essaug"]?.InnerText, intValue, 0));
Attributes = new ObservableCollection <CharacterAttrib>
{
_objCharacter.BOD,
_objCharacter.AGI,
_objCharacter.REA,
_objCharacter.STR,
_objCharacter.CHA,
_objCharacter.INT,
_objCharacter.LOG,
_objCharacter.WIL,
_objCharacter.EDG
};
if (_objCharacter.MAGEnabled)
{
Attributes.Add(_objCharacter.MAG);
if (_objCharacter.Options.MysAdeptSecondMAGAttribute && _objCharacter.IsMysticAdept)
{
Attributes.Add(_objCharacter.MAGAdept);
}
}
if (_objCharacter.RESEnabled)
{
Attributes.Add(_objCharacter.RES);
}
if (_objCharacter.DEPEnabled)
{
Attributes.Add(_objCharacter.DEP);
}
ResetBindings();
_objCharacter.RefreshAttributeBindings();
Timekeeper.Finish("create_char_attrib");
}
public async Task <bool> FilesDownloader(List <string> listOfUrl, string comicName, string chapterNumber, CommonInternalData.DownloadType downloadType, Xamarin.Forms.Button button)
{
int fileCount = 0;
//CommonFunctions commonFunctions = new CommonFunctions();
string baseDirectoryAddress = await GetDirectory(CommonFunctions.FileNameCleaner(comicName), chapterNumber);
foreach (string fileUrl in listOfUrl)
{
string downloadPercent = DownloadPercentage((double)fileCount, (double)listOfUrl.Count);
button.Text = downloadPercent + "%";
if (!string.IsNullOrEmpty(baseDirectoryAddress)) // Make directory and it returns a boolean as a result.
{
string filePath = baseDirectoryAddress + "/" + Convert.ToString(fileCount) + ".jpg";
bool isFilePresent = DependencyService.Get <IDirectory>().CheckExisingFile(filePath);
if (!isFilePresent) // File is not downloaded yet.
{
byte[] contents = null;
/*
* We can set the downloader and revert its contents to this byte[] contents and use it further.
*/
if (downloadType == CommonInternalData.DownloadType.RCO)
{
contents = await ImageDownloader(baseDirectoryAddress, fileUrl, Convert.ToString(fileCount));
}
if (contents == null) // If there's nothing, just move onto the next loop.
{
continue;
}
bool isFileDownloaded = DependencyService.Get <IDirectory>().CreateFile(filePath, contents);
if (!isFileDownloaded)
{
CommonInternalData.failedDownloadLinks.Add(fileUrl); // If failed, add to failed download list.
CurrentData.comic_response = "Download Failed";
}
else
{
CurrentData.comic_response = "Download Completed.";
CurrentData.comic_downloadPath = baseDirectoryAddress; // For opening the Explorer.
}
}
else
{
fileCount++;
continue; // File is already downloaded.
}
}
else
{
return(false);
}
fileCount++;
}
return(true);
}
public void GetUserTimeTest()
{
DateTime dt= new CommonFunctions().GetServerTime();
Console.Write(dt.ToString());
}
protected void ddlUpazilla_SelectedIndexChanged(object sender, EventArgs e)
{
ddlUnion.Items.Clear();
if (ddlUpazilla.SelectedIndex > 0)
{
List <ALRD_UnionInfoEntity> union = ALRD_UnionInfoService.GetService().GetAll(new ALRD_UnionInfoEntity {
UpazilaID = long.Parse(ddlUpazilla.SelectedValue)
}).ToList();
LoadComboRef(ref ddlUnion, union, CommonFunctions.GetPropertyName((ALRD_UnionInfoEntity x) => x.DESCRIPT), CommonFunctions.GetPropertyName((ALRD_UnionInfoEntity x) => x.COMPID));
}
}
//Biniding content
protected void BindContents(string search = "")
{
importjobManager objimportjob = new importjobManager();
DataTable dtcontents = new DataTable();
try
{
objimportjob.id = Convert.ToInt32(Request.QueryString["id"]);
objimportjob.productname = "";
//objlanguage.languagename = Server.HtmlEncode(txtsearch.Text.Trim());
if (pageNo == 0)
{
pageNo = 1;
}
objimportjob.pageNo = pageNo;
objimportjob.pageSize = pageSize;
objimportjob.SortExpression = SortExpression;
querystring = "&pageSize=" + ddlpageSize.SelectedValue;
dtcontents = objimportjob.SearchImportInventoryJobs();
totalrecs = objimportjob.TotalRecord;
if (pageNo == 1)
{
objimportjob.pageNo = 1;
pageNo = 1;
}
else if (pageNo == 0)
{
objimportjob.pageNo = 1;
pageNo = 1;
}
else
{
objimportjob.pageNo = (pageNo - 1) * pageSize;
}
objimportjob.pageSize = pageSize;
totalpages = totalrecs / pageSize;
if ((totalrecs % pageSize) > 0 && (totalrecs > pageSize))
{
totalpages += 1;
}
gvImportjob.DataSource = dtcontents;
gvImportjob.DataBind();
if (dtcontents.Rows.Count > 0)
{
lblinsertfilecount.Text = "Proccessed " + dtcontents.Rows[0]["Proccessed"] + " rows of which " + dtcontents.Rows[0]["NoErrorLine"] + " passed validation and " + dtcontents.Rows[0]["ErrorLine"] + " failed.";
int startRowOnPage = (gvImportjob.PageIndex * gvImportjob.PageSize) + 1;
int lastRowOnPage = startRowOnPage + gvImportjob.Rows.Count - 1;
int totalRows = totalrecs;
ltrcountrecord.Text = "<div class=\"countdiv\">Showing " + startRowOnPage.ToString() + " to " + lastRowOnPage + " of " + totalRows + " entries</div>";
}
String strpaging = CommonFunctions.AdminPaging(totalpages, pageNo, querystring, "ViewImportInventoryJobs.aspx");
ltrpaggingbottom.Text = strpaging;
//LoadDropDownList();
}
catch (Exception ex)
{
//throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gvCustomerLoan_RowEditing(object sender, GridViewEditEventArgs e)
{
ObjLoan = new clsLoan();
dtLoan = new DataTable();
clsComFun = new CommonFunctions();
int iLoanId;
string strValue = string.Empty;
int intMonth = 0, intYear = 0;
try
{
//BindLoanTypes();
iLoanId = Convert.ToInt32(((Label)gvCustomerLoan.Rows[e.NewEditIndex].FindControl("lblLoanId")).Text);
if (iLoanId > 0)
{
ObjLoan.LoanId = iLoanId;
dtLoan = ObjLoan.LoanWithSearchFilters();
if (dtLoan.Rows.Count > 0)
{
//Fill Loan Details
hdnCustomerId.Value = dtLoan.Rows[0]["CustomerId"].ToString();
hdnLoanId.Value = dtLoan.Rows[0]["LoanID"].ToString();
//Loan Details
txtLoanDate.Text = dtLoan.Rows[0]["LoanDate"].ToString();
ddlLoanType.SelectedValue = dtLoan.Rows[0]["LoanTypeID"].ToString();
txtLoanAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["LoanAmount"]));
txtEmiAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["InstallmentAmount"]));
strValue = dtLoan.Rows[0]["LoanPeriod"].ToString();
intYear = (System.Convert.ToInt32(strValue) / 12);
ddlLoanYear.SelectedValue = intYear.ToString();
intMonth = (System.Convert.ToInt32(strValue) - (intYear * 12));
ddlLoanMonth.SelectedValue = intMonth.ToString();
ddlCustomerPastLoanEMI.SelectedValue = dtLoan.Rows[0]["LoanPaidTypeID"].ToString();
txtCustomerLoanPurpose.Text = dtLoan.Rows[0]["LoanReason"].ToString();
txtTotalLoanInstallmentAmt.Text = CommonFunctions.FormatMoneyString(Convert.ToDecimal(dtLoan.Rows[0]["TotalInstallment"]));
BindCustomerDetails(Convert.ToInt64(dtLoan.Rows[0]["CustomerId"].ToString()));
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID1"]), "1");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID2"]), "2");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID3"]), "3");
BindWitnessDetails(Convert.ToInt64(dtLoan.Rows[0]["WitnessID4"]), "4");
EnableDisabledControls(false);
ShowHideLoanGrid(false);
ShowHideLoanWitnessFields(false);
}
}
}
catch (Exception) { }
finally
{
ObjLoan = null;
ObjCust = null;
dtLoan = null;
}
ShowHideLoanGrid(false);
EnableDisabledControls(false);
}
// Execute authorization query
private void ExecuteAuthorizationQuery()
{
try
{
List <Guid> sourceMeasurements;
lock (m_authorizationQueryLock)
{
sourceMeasurements = m_authorizationQueryIDs.ToList();
m_authorizationQueryIDs.Clear();
}
List <int> deviceIDs = new List <int>();
AdoDataConnection database = null;
// Query associated device ID list for given measurements
try
{
database = new AdoDataConnection(CommonFunctions.DefaultSettingsCategory);
string guidPrefix = database.DatabaseType == DatabaseType.Access ? "{" : "'";
string guidSuffix = database.DatabaseType == DatabaseType.Access ? "}" : "'";
string query = string.Format("SELECT DISTINCT DeviceID FROM ActiveMeasurement WHERE ProtocolType = 'Measurement' AND SignalID IN ({0})", sourceMeasurements.Select(signalID => guidPrefix + signalID.ToString() + guidSuffix).ToDelimitedString(", "));
DataTable measurementDevices = database.Connection.RetrieveData(database.AdapterType, query);
foreach (DataRow row in measurementDevices.Rows)
{
int?deviceID = row.ConvertNullableField <int>("DeviceID");
if (deviceID.HasValue)
{
// Validate that device ID is unique (not trusting all databases will handle DISTINCT properly)
if (deviceIDs.BinarySearch(deviceID.Value) < 0)
{
deviceIDs.Add(deviceID.Value);
deviceIDs.Sort();
}
}
}
}
finally
{
if ((object)database != null)
{
database.Dispose();
}
}
// Clear existing destination signal ID lists
lock (m_authorizedSignalIDs)
{
m_authorizedSignalIDs.Clear();
}
// Reset request and response counts to zero
m_requests = 0;
m_responses = 0;
// Reset state of response complete event (in case a prior event set never completed)
if ((object)m_responseComplete != null)
{
m_responseComplete.Reset();
}
// Send service commands to DataSubscribers to determine signal authorizations
foreach (int deviceID in deviceIDs)
{
// Send command for authorized signals for this device
CommonFunctions.SendCommandToService(string.Format("INVOKE {0} GetAuthorizedSignalIDs", deviceID));
m_requests++;
}
if (m_requests > 0)
{
// Wait for command responses allowing processing time for each
if ((object)m_responseComplete != null)
{
if (!m_responseComplete.WaitOne(m_requests * m_responseTimeout))
{
OnProcessException(new TimeoutException(string.Format("Timed-out after {0} seconds waiting for {1} service response{2}.", (m_requests * m_responseTimeout / 1000.0D).ToString("0.00"), m_requests, m_requests == 1 ? "" : "s")));
}
}
// Create a sorted list of the source measurements to use as a filter to authorized measurements
List <Guid> sourceFilter = new List <Guid>(sourceMeasurements);
sourceFilter.Sort();
Guid[] authorizedSignalIDs = null;
// Provide user with a distinct list of query results - if there are any
lock (m_authorizedSignalIDs)
{
if (m_authorizedSignalIDs.Count > 0)
{
authorizedSignalIDs = m_authorizedSignalIDs.Distinct().Where(signalID => sourceFilter.BinarySearch(signalID) >= 0).ToArray();
}
}
if (authorizedSignalIDs != null && authorizedSignalIDs.Length > 0)
{
OnAuthorizedMeasurements(authorizedSignalIDs);
}
}
}
catch (Exception ex)
{
OnProcessException(new InvalidOperationException("Authorized measurements query error: " + ex.Message, ex));
}
}
protected void gvRequisitionInquiry_RowDataBound(object sender, GridViewRowEventArgs e)
{
((BoundField)gvRequisitionInquiry.Columns[6]).DataFormatString = CommonFunctions.GetAppDateFormat();
}
protected void ProcessStep_StartStep(String stepName, String stepDescription, String debug)
{
String insertStatement = String.Empty;
Boolean success;
Mercury.Server.Data.AuthorityAccountStamp accountInfo = new Mercury.Server.Data.AuthorityAccountStamp(application);
try {
base.application.EnvironmentDatabase.BeginTransaction();
insertStatement = "INSERT INTO logs.MetricProcessStep (ProcessLogId, StepName, StepDescription, StartDate, Debug, ";
insertStatement = insertStatement + "CreateAuthorityName, CreateAccountId, CreateAccountName, CreateDate, ";
insertStatement = insertStatement + "ModifiedAuthorityName, ModifiedAccountId, ModifiedAccountName, ModifiedDate) ";
insertStatement = insertStatement + "VALUES (";
insertStatement = insertStatement + processLogId.ToString() + ", '" + CommonFunctions.SetValueMaxLength(stepName, 60) + "', '" + CommonFunctions.SetValueMaxLength(stepDescription, 120) + "', '" + DateTime.Now.ToString() + "', ";
insertStatement = insertStatement + "'" + CommonFunctions.SetValueMaxLength(debug.Replace("'", "''"), 3000) + "', ";
insertStatement = insertStatement + "'" + accountInfo.SecurityAuthorityNameSql + "', '" + accountInfo.UserAccountIdSql + "', '" + accountInfo.UserAccountNameSql + "', '" + DateTime.Now.ToString() + "', ";
insertStatement = insertStatement + "'" + accountInfo.SecurityAuthorityNameSql + "', '" + accountInfo.UserAccountIdSql + "', '" + accountInfo.UserAccountNameSql + "', '" + DateTime.Now.ToString() + "'";
insertStatement = insertStatement + ")";
success = base.application.EnvironmentDatabase.ExecuteSqlStatement(insertStatement.ToString(), 0);
if (!success)
{
throw base.application.EnvironmentDatabase.LastException;
}
processStepId = 0;
if (processStepId == 0) // RESET DOCUMENT ID CRITERIA
{
Object identity = base.application.EnvironmentDatabase.ExecuteScalar("SELECT @@IDENTITY").ToString();
if (!Int64.TryParse((String)identity, out processStepId))
{
throw new ApplicationException("Unable to retreive unique id.");
}
}
base.application.EnvironmentDatabase.CommitTransaction();
}
catch (Exception logException) {
System.Diagnostics.Trace.WriteLine(insertStatement);
System.Diagnostics.Trace.WriteLine(logException);
System.Diagnostics.Trace.Flush();
base.application.EnvironmentDatabase.RollbackTransaction();
}
return;
}
private void BindGrid()
{
dtRequisitionItemsTableAdapter RequisitionItemsAdapter = new dtRequisitionItemsTableAdapter();
gvRequisitionInquiry.DataSource = RequisitionItemsAdapter.GetDataByRequestInquiryParams(ddlToLocation.SelectedItem.Text.Trim(), ddlFromLocation.SelectedItem.Text, CommonFunctions.ConvertToUniversalDate(txtRequiredDateFrom.Text), CommonFunctions.ConvertToUniversalDate(txtRequiredDateTo.Text), ddlToWarehouse.SelectedItem.Text, ddlFromWarehouse.SelectedItem.Text);
gvRequisitionInquiry.DataBind();
}
private void lblName_Click(object sender, EventArgs e)
{
CommonFunctions objCommon = new CommonFunctions(_skill.CharacterObject);
objCommon.OpenPDF(_skill.Source+" "+_skill.Page);
}
