public void UpdateContact(int ContactID, int CustomerCode, string FirstName, string LastName, string Prefix, string Department, string CNIC, string JobTitle, string MobilePhone, string WorkPhone, string Email, string Address, string City, string State, string Country, string PinCode, string Gender, string Religion, string ContactType, int IsFav, int IsActive)
{
dynamic[,] para =
{
{ "@ContactID", ContactID },
{ "@CustomerCode", CustomerCode },
{ "@FirstName", FirstName },
{ "@LastName", LastName },
{ "@Prefix", Prefix },
{ "@Department", Department },
{ "@CNIC", CNIC },
{ "@JobTitle", JobTitle },
{ "@MobilePhone", MobilePhone },
{ "@WorkPhone", WorkPhone },
{ "@Email", Email },
{ "@Address", Address },
{ "@City", City },
{ "@State", State },
{ "@Country", Country },
{ "@PinCode", PinCode },
{ "@Gender", Gender },
{ "@Religion", Religion },
{ "@ContactType", ContactType },
{ "@IsFav", IsFav },
{ "@IsActive", IsActive }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectContactID = objDBAcess.executeProc("sp_UpdateCustomerContacts", para);
}
public object UpdateTAF(int TAFID, string TAFFormNo, string RevisionNo, string Sites_JobLocation, string AccountManager, string BusinessUnit, int LastMileTopology, int Capacity, int InterfaceHandoff, int LogicalTopology, string RestorabilityMethod, int AdditionalEquipment, int SLARequirement, string AdditionRequirement)
{
dynamic[,] para =
{
{ "@TAFID", TAFID },
{ "@TAFFormNo", TAFFormNo },
{ "@RevisionNo", RevisionNo },
{ "@Sites_JobLocation", Sites_JobLocation },
{ "@AccountManager", AccountManager },
{ "@BusinessUnit", BusinessUnit },
{ "@LastMileTopology", LastMileTopology },
{ "@Capacity", Capacity },
{ "@InterfaceHandoff", InterfaceHandoff },
{ "@LogicalTopology", LogicalTopology },
{ "@RestorabilityMethod", RestorabilityMethod },
{ "@AdditionalEquipment", AdditionalEquipment },
{ "@SLARequirement", SLARequirement },
{ "@AdditionRequirement", AdditionRequirement },
//{ "@ServiceParameter", ServiceParameter},
//{ "@Comments", Comments},
//{ "@AdditionalEquipmentDesc", AdditionalEquipmentDesc},
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_InsertTAF", para, "@TAFID");
DataTable dt_UPDTAF = objDBAcess.SP_Datatable("sp_UpdateTAF", para);
return(dt_UPDTAF);
}
/* public static MathNet.Numerics.LinearAlgebra.Double.DenseMatrix matrix(string str)
* {
* if(str.Contains("{")&& str.Contains("}"))
* return MathNet.Numerics.LinearAlgebra.Double.DenseMatrix.OfArray(Accord.Math.Matrix.Parse(str, Accord.Math.CSharpMatrixFormatProvider.InvariantCulture));
* else if (str.Contains("[") && str.Contains("]"))
* return MathNet.Numerics.LinearAlgebra.Double.DenseMatrix.OfArray(Accord.Math.Matrix.Parse(str, Accord.Math.OctaveMatrixFormatProvider.InvariantCulture));
* else
* return MathNet.Numerics.LinearAlgebra.Double.DenseMatrix.OfArray(Accord.Math.Matrix.Parse(str, Accord.Math.DefaultMatrixFormatProvider.InvariantCulture));
* }*/
public static dynamic matrix(dynamic[,] array) //TODO: test it
{
for (int j = 0; j < array.GetLength(0); j++)
{
for (int k = 0; k < array.GetLength(1); k++)
{
//writeln(array[0,0].GetType());
if (array[j, k] is System.Numerics.Complex)
{
var narray = new System.Numerics.Complex[array.GetLength(0), array.GetLength(1)];
for (int j2 = 0; j2 < array.GetLength(0); j2++)
{
for (int k2 = 0; k2 < array.GetLength(1); k2++)
{
narray[j2, k2] = (System.Numerics.Complex)array[j2, k2];
}
}
return(MathNet.Numerics.LinearAlgebra.Complex.DenseMatrix.OfArray(narray));
}
}
}
var narray2 = new double[array.GetLength(0), array.GetLength(1)];
for (int j2 = 0; j2 < array.GetLength(0); j2++)
{
for (int k2 = 0; k2 < array.GetLength(1); k2++)
{
narray2[j2, k2] = (double)array[j2, k2];
}
}
return(MathNet.Numerics.LinearAlgebra.Double.DenseMatrix.OfArray(narray2));
}
//public object CreateOpportunityDetails(string SID_A_Address, string SID_A_Area, string SID_A_Building, string SID_A_City)
//{
// dynamic[,] para = {
// { "@SID_A_Address", SID_A_Address },
// { "@SID_A_Area", SID_A_Area },
// { "@SID_A_Building", SID_A_Building },
// { "@SID_A_City", SID_A_City }
// };
// clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
// object objectCustomerID = objDBAcess.executeProc("sp_InsertOpportunityDetails", para);
// return objectCustomerID;
//}
public object CreateOpportunityDetails(string Site_A_Address, int Site_A_Country, int Site_A_City, string Site_B_Address, int Site_B_Country, int Site_B_City, int Name, int QuantityUOM, int Interface, string Last_Mile_Protection, string Wet_Portion_Restorability, string SLA, DateTime RFS_Date_Duration, string Contract_Term, string Win_Loss, int Currency, int OppID)
{
dynamic[,] para =
{
{ "@Site_A_Address", Site_A_Address },
{ "@Site_A_Country", Site_A_Country },
{ "@Site_A_City", Site_A_City },
{ "@Site_B_Address", Site_B_Address },
{ "@Site_B_Country", Site_B_Country },
{ "@Site_B_City", Site_B_City },
{ "@Name", Name },
{ "@QuantityUOM", QuantityUOM },
{ "@Interface", Interface },
{ "@Last_Mile_Protection", Last_Mile_Protection },
{ "@Wet_Portion_Restorability", Wet_Portion_Restorability },
{ "@SLA", SLA },
{ "@RFS_Date_Duration", RFS_Date_Duration },
{ "@Contract_Term", Contract_Term },
{ "@Win_Loss", Win_Loss },
{ "@Currency", Currency },
{ "@OppID", OppID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_Ins_OpportunityDetails_New", para);
return(objectCustomerID);
}
public object UpdateOpportunityEBU(int OppId, string OppName, int CustCode, int PartnerContactID, int KAMID, int WorkingBy, int CurrencyID, int OppStageID, int OppStatusID, string WinProbibality, string GroupRTR, String DTProposalIntDate, string OppRemarks, string NegotiationStatus, string ProposalLastRevesionDate, string NegotiationFollowUpDate, string NegotiationRemarks, string NegotiationResumeDate, string NegotiationHoldReason, String OrderDate, string WonLostReason, String DeploymentDate)
{
//String NRFRequestDate
dynamic[,] para =
{
{ "@OppId", OppId },
{ "@OppName", OppName },
{ "@CustCode", CustCode },
{ "@PartnerContactID", PartnerContactID },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@CurrencyID", CurrencyID },
{ "@OppStageID", OppStageID },
{ "@OppStatusID", OppStatusID },
{ "@WinProbability", WinProbibality },
{ "@GroupRTR", GroupRTR },
{ "@ProposalIntDate", DTProposalIntDate },
{ "@Remarks", OppRemarks },
{ "@NegotiationStatus", NegotiationStatus },
{ "@NegotiationProposalRevisionDate", ProposalLastRevesionDate },
{ "@NegotiationFollowUpDate", NegotiationFollowUpDate },
{ "@NegotiationRemarks", NegotiationRemarks },
{ "@NegotiationResumeDate", NegotiationResumeDate },
{ "@NegotiationHoldReason", NegotiationHoldReason },
{ "@OrderDate", OrderDate },
{ "@OppCloseReason", WonLostReason },
{ "@DeploymentDate", DeploymentDate }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.executeProc("sp_UpdateOpportunityMaster_EBU", para);
return(objectOpportunityID);
}
public object UpdateOpportunity(int OppId, string OppName, int StageID, int PartnerID, int CustCode, int CurrencyID, int StatusID, string WinProbability, int KAMID, int WorkingBy, string Attachment1, int LastUpdateBy, int IsBudgetaryQuote, DateTime BudgetaryQuoteDate, DateTime QuoteProposalDate)
{
dynamic[,] para =
{
{ "@OppId", OppId },
{ "@OppName", OppName },
{ "@StageID", StageID },
{ "@PartnerID", PartnerID },
{ "@CustCode", CustCode },
{ "@CurrencyID", CurrencyID },
{ "@StatusID", StatusID },
{ "@WinProbability", WinProbability },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@Attachment1", Attachment1 },
{ "@LastUpdateBy", LastUpdateBy },
{ "@IsBudgetaryQuote", IsBudgetaryQuote },
{ "@BudgetaryQuoteDate", BudgetaryQuoteDate },
{ "@QuoteProposalDate", QuoteProposalDate }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.executeProc("sp_UpdateOpportunityMaster_New", para);
return(objectOpportunityID);
}
/*public object CreateOpportunity(string OppName, string PartnerID, string CustCode, string ContactID, string KAMID, string WinProbability, string CurrencyID, string StageID, int StatusID
* , int IsActive, string IsBudgetaryQuote, string BudgetaryQuoteDate, string BudgetaryQuoteAmount
* , string QuoteProposalDate, string NegotiatedMMR, string NegotiatedAmount, string NegotiatedRevenue)*/
// public object CreateOpportunity(string OppName, string PartnerID, string CustCode, string ContactID, string KAMID, string WinProbability, string CurrencyID, string StageID, int StatusID
// , int IsActive)
//{
// //dynamic[,] para = {
// // { "@OppName", OppName },
// // { "@PartnerID", PartnerID },
// // { "@CustCode", CustCode },
// // { "@ContactID", ContactID },
// // { "@KAMID", KAMID },
// // { "@WinProbability", WinProbability },
// // { "@CurrencyID", CurrencyID },
// // { "@StageID" , StageID},
// // { "@StatusID", StatusID},
// // { "@IsActive", IsActive},
// // { "@IsBudgetaryQuote", IsBudgetaryQuote},
// // { "@BudgetaryQuoteDate", BudgetaryQuoteDate},
// // { "@BudgetaryQuoteAmount", BudgetaryQuoteAmount},
// // { "@QuoteProposalDate", QuoteProposalDate},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // { "@NegotiatedAmount", NegotiatedAmount},
// // { "@NegotiatedRevenue", NegotiatedRevenue},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // { "@NegotiatedMMR", NegotiatedMMR},
// // };
// dynamic[,] para = {
// { "@OppName", OppName },
// { "@PartnerID", PartnerID },
// { "@CustCode", CustCode },
// { "@ContactID", ContactID },
// { "@KAMID", KAMID },
// { "@WinProbability", WinProbability },
// { "@CurrencyID", CurrencyID },
// { "@StageID" , StageID},
// { "@StatusID", StatusID},
// { "@IsActive", IsActive},
// };
// clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
// object objectCustomerID = objDBAcess.executeProc("sp_InsertOpportunity", para);
// return objectCustomerID;
//}
public object CreateOpportunity(string OppName, string LOB_ID, int StageID, int PartnerID, int CustCode, int ContactID, string WinProbability, int KAMID, int WorkingBy, string Attachment1, int LastUpdateBy)
{
dynamic[,] para =
{
{ "@OppName", OppName },
{ "@LOB_ID", LOB_ID },
{ "@PartnerID", PartnerID },
{ "@CustCode", CustCode },
{ "@PartnerContactID", ContactID },
{ "@KAMID", KAMID },
{ "@WorkingBy", WorkingBy },
{ "@WinProbability", WinProbability },
{ "@CurrencyID", 1 },
{ "@OppStageID", StageID },
{ "@OppStatusID", 1 },
{ "@IsActive", 1 },
{ "@Attachment1", Attachment1 },
{ "@Attachment2", Attachment1 },
{ "@LastUpdateBy", LastUpdateBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_Sales_InsertOpportunity", para, "@OppId");
return(objectOpportunityID);
}
public object CreateOpportunityDetailsForEBU(int OppID, int infraID, int ServiceUnitID, int RegionID, int City, int LocationCode, int BuildingID, string Site_A_Address, string Site_B_Address, string Latitude, string Longitude, int POC, int CircuitTypeID, string Remarks, int Estimated_Price, int Amount, int NRCActual, int MRCActual, int NRR, int MRR, int ROI, int TermProfit, int TermRevenue, int RecurringMarginage, int NonRecurringMargin, string NRFRequestDate, int LastUpdatedBy)
{
dynamic[,] para = { { "@OppID", OppID },
{ "@InfraID", infraID },
{ "@ServiceUnitID", ServiceUnitID },
{ "@RegionID", RegionID },
{ "@City", City },
{ "@LocationCode", LocationCode },
{ "@BuildingID", BuildingID },
{ "@Site_A_Address", Site_A_Address },
{ "@Site_B_Address", Site_B_Address },
{ "@Lat", Latitude },
{ "@Long", Longitude },
{ "@POC", POC },
{ "@CircuitTypeID", CircuitTypeID },
{ "@Remarks", Remarks },
{ "@Estimated_Price", Estimated_Price },
{ "@Amount", Amount },
{ "@NRCActual", NRCActual },
{ "@MRCActual", MRCActual },
{ "@NRR", NRR },
{ "@MRR", MRR },
{ "@LastUpdatedBy", LastUpdatedBy } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectOpportunityID = objDBAcess.InsertProc_WithOutput("sp_Ins_OpportunityDetails_EBU", para, "@OppRenID");
return(objectOpportunityID);
//clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//object objectCustomerID = objDBAcess.executeProc("sp_Ins_OpportunityDetails_EBU", para);
//return objectCustomerID;
}
//////////////////////////////////////////////////
///
void changeCounter(object sender, KeyEventArgs e)
{
var obj = ((dynamic)sender).Name;
dynamic[,] arr = { { tbxX, tbxY }, { tbxGotoX, tbxGotoY } };
int n = 0;
for (int i = 0; i < arr.GetLength(0); i++)
{
for (int j = 0; j < arr.GetLength(1); j++)
{
if (arr[i, j].Name == obj)
{
n = i;
}
}
}
if (e.KeyCode == Keys.Right)
{
arr[n, 0].Text = (int.Parse(arr[n, 0].Text) + 1).ToString();
}
else if (e.KeyCode == Keys.Left)
{
arr[n, 0].Text = (int.Parse(arr[n, 0].Text) - 1).ToString();
}
else if (e.KeyCode == Keys.Up)
{
arr[n, 1].Text = (int.Parse(arr[n, 1].Text) - 1).ToString();
}
else if (e.KeyCode == Keys.Down)
{
arr[n, 1].Text = (int.Parse(arr[n, 1].Text) + 1).ToString();
}
}
public DataTable SP_Datatable(string SP_Name, dynamic[,] Par)
{
try
{
objSqlCon.Open();
objSqlCmd = new SqlCommand(SP_Name, objSqlCon);
objSqlCmd.CommandType = CommandType.StoredProcedure;
objSqlCmd.CommandTimeout = 45;
int int_LoopTerminationPoint = Par.Length / 2;
for (Int16 i = 0; i < int_LoopTerminationPoint; i++)
{
objSqlCmd.Parameters.AddWithValue(Par[i, 0], Par[i, 1]);
}
objDT = new DataTable();
objAdp = getAdapterObject();
objAdp.SelectCommand = objSqlCmd;
objAdp.Fill(objDT);
return(objDT);
}
catch (Exception ex)
{
objDT = null;
return(objDT);
}
finally
{
objSqlCon.Close();
}
}
public DataFrame(List<string> columnHeaders, List<string> rowHeaders)
{
// todo check that column and row headers being passed contain no duplicates
fColumnHeaders = columnHeaders;
fRowHeaders = rowHeaders;
fValues = new dynamic[fRowHeaders.Count, fColumnHeaders.Count];
}
/// <summary>
/// 热力图
/// </summary>
private void OpenDataMap_Hot()
{
Range rg = FxtAddIn.FxtApp.Application.Selection;
if (rg == null || rg[1, 1].Value == null)
{
MessageBox.Show("请选择数据区域，并保证按经度、维度、数据排列");
return;
}
try
{
dynamic[,] data = rg.Value;
string datastr = "";
for (int i = 1; i <= rg.Rows.Count; i++)
{
if (isNumeric(data[i, 1].ToString()))
{
datastr += string.Format("{{ \"lng\": {0}, \"lat\": {1}, \"count\": {2} }}", data[i, 1], data[i, 2], data[i, 3]);
if (i < rg.Rows.Count)
{
datastr += ",";
}
}
}
string str = FXTExcelAddIn.Properties.Resources.map;
str = str.Replace("@data", datastr);
OpenStat(str);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 标准化用途
/// </summary>
public bool BiaoZhunHua_Use()
{
try
{
SetTimeStatus(txtStatus, "标准化用途", true);
Dictionary <string, string> dict = FxtRibbon.FindCol();
//取消筛选，显示全部数据
FxtAddIn.FxtWorkSheet.AutoFilterMode = false;
string col1 = dict["总楼层"];
string col2 = dict["建筑面积"];
string col3 = dict["建筑类型"];
string col = dict["用途"];
string formula = string.Format(Dict.MathDict["用途"], col3, col2, col1);
//添加辅助列
Range rg = FxtAddIn.FxtWorkSheet.Cells[2, FxtAddIn.FxtWorkSheet.UsedRange.Columns.Count + 1];
rg.Value = formula;
rg = rg.get_Resize(FxtAddIn.FxtWorkSheet.UsedRange.Rows.Count - 1, 1);
rg.FillDown();
dynamic[,] vals = rg.Value2;
Range rg1 = FxtAddIn.FxtWorkSheet.get_Range(col + "2", col + FxtAddIn.FxtWorkSheet.UsedRange.Rows.Count.ToString());
rg1.Value = vals;
rg.EntireColumn.Delete();
SetTimeStatus(txtStatus, "标准化用途", false);
return(true);
}
catch (Exception ex)
{
SetStatus(EnumHelper.LabelStatus.Faild, ex.Message);
return(false);
}
}
public object CreateContact(int CustCode,
int CityID,
string CC_Title,
string CC_Name,
string CC_Contact,
string CC_Email,
string CC_Mobile,
string CC_Address,
int ContactTypeID,
string Religion,
string Gender,
int TransactionBy
)
{
dynamic[,] para =
{
{ "@CustCode", CustCode },
{ "@CityID", CityID },
{ "@CC_Title", CC_Title },
{ "@CC_Name", CC_Name },
{ "@CC_Contact", CC_Contact },
{ "@CC_Email", CC_Email },
{ "@CC_Mobile", CC_Mobile },
{ "@CC_Address", CC_Address },
{ "@ContactTypeID", ContactTypeID },
{ "@Religion", Religion },
{ "@Gender", Gender },
{ "@TransactionBy", TransactionBy }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
object objectCustomerID = objDBAcess.executeProc("sp_Sales_InsertCustomerContact", para);
return(objectCustomerID);
}
public DataTable GetOpportunityProposal(int OppID)
{
dynamic[,] para = { { "@OppID", OppID } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_Proposal", para);
return(dt_GD);
}
public DataTable GetNRFKeyForPDF(int NRFID)
{
dynamic[,] para = { { "@NRFID", NRFID } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GNKFP = objDBAcess.SP_Datatable("sp_GetNRFKeyForPDF", para);
return(dt_GNKFP);
}
public DataTable GetPrimaryContacts(string RefID)
{
dynamic[,] para = { { "@RefID", RefID } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GOS = objDBAcess.SP_Datatable("sp_Sales_GetCustomerContact", para);
return(dt_GOS);
}
public DataTable GetRegionByCityID(int City)
{
dynamic[,] para = { { "@City", City } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//DataTable dt = objDBAcess.SP_DatatableWithTwoParameters("sp_GetNullItems", para);
DataTable dt_GRBCI = objDBAcess.SP_Datatable("sp_GetRegionByCity", para);
return(dt_GRBCI);
}
public DataFrame(List<string> columnHeaders, List<string> rowHeaders, dynamic[,] values)
{
// todo check that column and row headers being passed contain no duplicates
fColumnHeaders = columnHeaders;
fRowHeaders = rowHeaders;
// todo dimensions are for losers
fValues = values;
}
public DataTable GetAreabyAreaID(int AreaID)
{
dynamic[,] para = { { "@AreaID", AreaID } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//DataTable dt = objDBAcess.SP_DatatableWithTwoParameters("sp_GetNullItems", para);
DataTable dt_GABAI = objDBAcess.SP_Datatable("Get_AreabyAreaID", para);
return(dt_GABAI);
}
public void loadData(string sourcePath)
{
try
{
using (StreamReader r = new StreamReader(sourcePath))
{
string json = r.ReadToEnd();
JavaScriptSerializer js = new JavaScriptSerializer();
var k = js.Deserialize <dynamic>(json);
//Row count
int count = 0;
foreach (dynamic row in k)
{
count++;
}
//Populate First Row
int i = 0;
foreach (dynamic row in k)
{
int j = 0;
if (i == 0)
{
arrFeed = new dynamic[count, row.Count];
foreach (System.Collections.Generic.KeyValuePair <string, dynamic> col in row)
{
arrFeed[i, j] = (dynamic)col;
j++;
}
i++;
}
else
{
break;
}
}
//dataFeed = JsonConvert.DeserializeObject<List<dynamic>>(json);
i = 0;
foreach (dynamic row in k)
{
int j = 0;
foreach (System.Collections.Generic.KeyValuePair <string, dynamic> col in row)
{
arrFeed[i, getIndex(col.Key)] = col;
j++;
}
i++;
}
}
}
catch (Exception ex)
{
Console.WriteLine("Issue in load data");
Console.WriteLine(ex.InnerException);
}
}
public DataTable GetEBUOpportunity(string LOB_ID)
{
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
dynamic[,] para = { { "@LOB_ID", LOB_ID } };
DataTable dt_GAO = objDBAcess.SP_Datatable("sp_Get_OpportunityEBU", para);
return(dt_GAO);
}
public bool Enviar(Cardapio_Item cardapio_item_novo, SqlDataReader retorno)
{
BancoTools banco = new BancoTools();
if (retorno != null)
{
if (true)
{
Cardapio_Item Cardapio_Item_antigo = new Cardapio_Item();
while (retorno.Read())
{
Cardapio_Item_antigo.Descricao = retorno["Descricao"].ToString();
Cardapio_Item_antigo.ic_Ativo = Convert.ToByte(retorno["ic_Ativo"]);
Cardapio_Item_antigo.ic_Destaque = Convert.ToByte(retorno["ic_Destaque"]);
Cardapio_Item_antigo.id_Cardapio = Convert.ToInt32(retorno["id_Cardapio"]);
Cardapio_Item_antigo.id_Cardapio_Item = Convert.ToInt32(retorno["id_Cardapio_Item"]);
Cardapio_Item_antigo.id_Tipo = Convert.ToInt32(retorno["id_Tipo"]);
Cardapio_Item_antigo.Nome = retorno["Nome"].ToString();
Cardapio_Item_antigo.Valor = Convert.ToInt32(retorno["Valor"]);
Cardapio_Item_antigo.vl_Desconto = Convert.ToInt32(retorno["vl_Desconto"]);
}
dynamic[,] resultado = banco.compara_objetos(cardapio_item_novo, Cardapio_Item_antigo);
string tabela = "Cardapio_Item";
if (resultado[0, 0] == true)
{
var query = banco.monta_update(resultado[0, 1], tabela, resultado[0, 2]);
banco.ExecuteNonQuery(query);
}
return(false);
}
}
else
{
var query = "insert into Cardapio_Item values (@Tipo,'@Nome',@Valor,'@Descricao',@Desconto,@Destaque,@Cardapio,@Ativo)";
query = query.Replace("@Tipo", cardapio_item_novo.id_Tipo.ToString())
.Replace("@Nome", cardapio_item_novo.Nome)
.Replace("@Valor", cardapio_item_novo.Valor.ToString().Replace(",", "."))
.Replace("@Descricao", cardapio_item_novo.Descricao)
.Replace("@Desconto", cardapio_item_novo.vl_Desconto.ToString().Replace(",", "."))
.Replace("@Destaque", cardapio_item_novo.ic_Destaque.ToString())
.Replace("@Cardapio", cardapio_item_novo.id_Cardapio.ToString())
.Replace("@Ativo", cardapio_item_novo.ic_Ativo.ToString());
try
{
banco.ExecuteNonQuery(query);
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public DataTable GetDefaultItems(float Distance, int InfraType, int BuildID, int City, int AreaID)
{
//string[,] para = { { "@Distance", Distance.ToString() }, { "@InfraType", InfraType.ToString() }, { "@BuildID", BuildID.ToString() } };
dynamic[,] para = { { "@Distance", Distance }, { "@InfraType", InfraType }, { "@BuildID", BuildID }, { "@City", City }, { "@AreaID", AreaID } };
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
//DataTable dt = objDBAcess.SP_DatatableWithTwoParameters("sp_GetNullItems", para);
DataTable dt_GDI = objDBAcess.SP_Datatable("sp_InfraBasedItems", para);
return(dt_GDI);
}
static void FirstArea(dynamic[,] array)
{
for (int i = 0; i < array.GetLength(0); i++)
{
for (int j = 0; j <= i; j++)
{
array[i, j] = ' ';
}
}
}
public DataTable GetCustomerNRFDetail(int NRFID)
{
dynamic[,] para =
{
{ "@NRFID", NRFID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GCND = objDBAcess.SP_Datatable("sp_GetCustomerNRFDetail", para);
return(dt_GCND);
}
public DataTable GetOpportunityByID(int OppID)
{
dynamic[,] para =
{
{ "OppID", @OppID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GAO = objDBAcess.SP_Datatable("sp_Get_OpportunityById", para);
return(dt_GAO);
}
public DataTable GetTAFData(int TAFID)
{
dynamic[,] para =
{
{ "@TAFID", TAFID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GCNM = objDBAcess.SP_Datatable("sp_GetTAFData", para);
return(dt_GCNM);
}
public DataTable GetOpportunityRevenueDetailsEBU(int OppRevnueID)
{
dynamic[,] para =
{
{ "@RevenueID", OppRevnueID }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GD = objDBAcess.SP_Datatable("Get_OpportunityRevenueDatailEBU", para);
return(dt_GD);
}
public DataTable GetCustomerNRFMasterForDetail(int CustomerCode)
{
dynamic[,] para =
{
{ "@CustomerCode", CustomerCode }
};
clsDBAccess objDBAcess = new clsDBAccess(constr, _eDBType);
DataTable dt_GCNM = objDBAcess.SP_Datatable("sp_GetCustomerNRFMasterForDetail", para);
return(dt_GCNM);
}
static void PrintArray(dynamic[,] array)
{
for (int i = 0; i < array.GetLength(0); i++)
{
for (int j = 0; j < array.GetLength(1); j++)
{
Console.Write(array[i, j] + "\t");
}
Console.WriteLine();
}
}
static void TransposeMatrix(dynamic[,] array)
{
for (int i = 0; i < array.GetLength(0); i++)
{
for (int j = i + 1; j < array.GetLength(1); j++)
{
var temp = array[i, j];
array[i, j] = array[j, i];
array[j, i] = temp;
}
}
}
//matrix constructor
public Matrix(int rows, int columns)
{
this.rows = rows;
this.columns = columns;
this.matrix = new dynamic[rows, columns];
}
