//settings methods
//other methods
#endregion
static MainViewModel()
{
if (AutoWorkTimer == null)
{
var single = new DispatcherTimer {
Interval = TimeSpan.FromSeconds(3600)
};
AutoWorkTimer = single;
}
if (SettingModel == null)
{
var single = new MainSettingModel();
SettingModel = single;
}
if (LogVm == null)
{
var single = new LogViewModel();
LogVm = single;
}
if (DocumentAdderModel == null)
{
var single = new MainModel();
DocumentAdderModel = single;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var model = new MainSettingModel();
model.Email = TextBox_Email.Text;
model.Eng_Address = TextBox_Eng.Text;
model.FaceBook = TextBox_Facebook.Text;
model.Instagram = TextBox_Insta.Text;
model.Linkedin = TextBox_Linkedin.Text;
model.Per_Address = TextBox_per.Text;
model.PhoneNumber = TextBox_Phone.Text;
model.SEO_discription = TextBox_SEO_D.Text;
model.SEO_Keyword = TextBox_SEO_K.Text;
model.SiteName = TextBox_SiteName.Text;
model.SiteDiscription = TextBox_Site_D.Text;
model.Twitter = TextBox_twitter.Text;
Logic.UpdateMainSetting(model);
}
public string UpdateMainSetting(MainSettingModel model)
{
string s = "";
List <ExcParameters> parss;
ExcParameters par;
base.Connect();
////////Eng_Address
DataTable dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Eng_Address'");
parss = new List <ExcParameters>();
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Eng_Address"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Eng_Address
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
////////Facebook
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Facebook'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Facebook"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.FaceBook
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Instagram
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Instagram'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Instagram"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Instagram
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Linkedin
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N''");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Linkedin"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Linkedin
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Per_Address
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Per_Address'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Per_Address"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Per_Address
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Site_Email
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_Email'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Site_Email"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Email
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Site_Phone
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_Phone'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Site_Phone"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.PhoneNumber
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Site_SEO_Discription
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_SEO_Discription'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Site_SEO_Discription"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.SEO_discription
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Site_SEO_Keyword
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_SEO_Keyword'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Site_SEO_Keyword"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.SEO_Keyword
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////SiteDiscription
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'SiteDiscription'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "SiteDiscription"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.SiteDiscription
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////SiteName
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'SiteName'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "SiteName"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.SiteName
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////Twitter
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Twitter'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "Twitter"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.Twitter
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////
base.DC();
if (s == "111111111111")
{
return("Success");
}
else
{
return("Fail");
}
}
public MainSettingModel GetMainSetting()
{
MainSettingModel model = new MainSettingModel();
base.Connect();
////////Eng_Address
DataTable dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Eng_Address'");
if (dt.Rows.Count != 0)
{
model.Eng_Address = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Eng_Address = "";
}
////////Facebook
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Facebook'");
if (dt.Rows.Count != 0)
{
model.FaceBook = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.FaceBook = "";
}
/////////Instagram
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Instagram'");
if (dt.Rows.Count != 0)
{
model.Instagram = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Instagram = "";
}
/////////Linkedin
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Linkedin'");
if (dt.Rows.Count != 0)
{
model.Linkedin = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Linkedin = "";
}
/////////Per_Address
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Per_Address'");
if (dt.Rows.Count != 0)
{
model.Per_Address = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Per_Address = "";
}
/////////Site_Email
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_Email'");
if (dt.Rows.Count != 0)
{
model.Email = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Email = "";
}
/////////Site_Phone
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_Phone'");
if (dt.Rows.Count != 0)
{
model.PhoneNumber = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.PhoneNumber = "";
}
/////////Site_SEO_Discription
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_SEO_Discription'");
if (dt.Rows.Count != 0)
{
model.SEO_discription = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.SiteDiscription = "";
}
/////////Site_SEO_Keyword
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Site_SEO_Keyword'");
if (dt.Rows.Count != 0)
{
model.SEO_Keyword = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.SEO_Keyword = "";
}
/////////SiteDiscription
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'SiteDiscription'");
if (dt.Rows.Count != 0)
{
model.SiteDiscription = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.SiteDiscription = "";
}
/////////SiteName
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'SiteName'");
if (dt.Rows.Count != 0)
{
model.SiteName = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.SiteName = "";
}
/////////Twitter
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'Twitter'");
if (dt.Rows.Count != 0)
{
model.Twitter = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.Twitter = "";
}
/////////
base.DC();
return(model);
}
