public static bool ChechRights(int UId, object RightsOn,string ColName)
{
bool IsRightGiven = false;
try
{
string SS = "Select " + ColName + " From UserConfiguration Where U_UId = " + UId + " And U_MId = " + RightsOn.ToString() + "";
System.Data.DataTable Dt = new ClsDataAccess().GetDataTable(SS);
if (Dt.Rows.Count > 0)
{
IsRightGiven = bool.Parse(Dt.Rows[0][ColName].ToString());
}
}
catch (Exception Erp)
{
clsGeneral.ShowErrMsg(Erp.Message);
IsRightGiven = false;
}
if (IsRightGiven == false)
{
clsGeneral.ShowMessage("You Do not Have Rights to Access This Module");
}
return IsRightGiven;
}
static void Main()
{
try
{
RegistryKey key;
key = Registry.CurrentUser.OpenSubKey("Control Panel\\International", true);
if (key.ToString().Trim() != "")
{
key.SetValue("sShortDate", "dd/MM/yyyy");
}
}
catch
{
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
ClsDataAccess ObjDataAccess = new ClsDataAccess();
bool chk_file = false;
chk_file = System.IO.File.Exists("Finance.stl");
if (chk_file == false)
{
Frm_SqlSettings sqlSetting = new Frm_SqlSettings();
sqlSetting.ShowDialog();
}
else
{
StreamReader objReader = new StreamReader("Finance.stl");
Program.connectionString = objReader.ReadLine();
objReader.Close();
objReader.Dispose();
try
{
ObjDataAccess.CreateConnection();
}
catch
{
clsGeneral.ShowErrMsg("Error In Connection");
File.Delete("Finance.stl");
Frm_SqlSettings sqlSetting = new Frm_SqlSettings();
sqlSetting.ShowDialog();
if (sqlSetting.DialogResult == DialogResult.Yes)
{
StreamWriter SW;
SW = File.CreateText("Finance.stl");
SW.WriteLine(Program.connectionString);
SW.Close();
SW.Dispose();
}
else
{
Application.Exit();
return;
}
}
}
string[] connSplit = Program.connectionString.Split(';');
if (connSplit.Length == 6)
{
string[] DataSourceName = connSplit[0].Split('=');
string[] DataBaseName = connSplit[1].Split('=');
Program.DataBaseName = DataBaseName[1].ToString();
}
else if (connSplit.Length > 6)
{
string[] DataSourceName = connSplit[0].Split('=');
string[] DataBaseName = connSplit[1].Split('=');
string[] UserName = connSplit[2].Split('=');
string[] PassWord = connSplit[3].Split('=');
Program.DataBaseName = DataBaseName[1].ToString();
Program.ServerName = DataSourceName[1].ToString();
Program.ServerUserId = UserName[1].ToString();
Program.ServerPassword = PassWord[1].ToString();
}
//========================================================================
try
{
string SS = "Create View vw_Form13 As ";
SS = SS + " Select '' As CompanyName,'' As Address1, ";
SS = SS + " '' As Address2,'' As Date,'' As ContactName, ";
SS = SS + " '' As LicenseNo,'' As SNo,'' As Debtor, ";
SS = SS + " '' As AddressDebtor,'' As LoanAmount, ";
SS = SS + " '' As DateLoan,'' As DateMaturity, ";
SS = SS + " '' As Balance,'' As Rate,'' As [Security], ";
SS = SS + " '' As Documents,'' As Information ";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "CREATE TABLE [dbo].[LoanDocuments]([DId] [int] ";
SS = SS + " IDENTITY(1,1) NOT NULL, [D_LId] [int] NULL, ";
SS = SS + " [D_DId] [int] NULL, CONSTRAINT [PK_LoanDocuments] ";
SS = SS + " PRIMARY KEY CLUSTERED ( [DId] ASC )WITH ";
SS = SS + " (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "CREATE TABLE [ChequeDetails]( ";
SS = SS + " [S_Id] [int] , ";
SS = SS + " [S_SNo] [int] , ";
SS = SS + " [S_ChequeDate] [varchar](max), ";
SS = SS + " [S_ChequeNo] [varchar](max) ) ";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "CREATE TABLE [dbo].[UserMaster]( ";
SS = SS + " [UId] [int] IDENTITY(1,1) NOT NULL, ";
SS = SS + " [UName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, ";
SS = SS + " [ULoginName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, ";
SS = SS + " [UPassword] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, ";
SS = SS + " CONSTRAINT [PK_UserMaster] PRIMARY KEY CLUSTERED ";
SS = SS + " ([UId] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] ";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "CREATE TABLE [dbo].[UserConfiguration]( ";
SS = SS + " [U_UId] [int] NULL,[U_MId] [int] NULL, ";
SS = SS + " [U_Save] [bit] NULL,[U_Delete] [bit] NULL, ";
SS = SS + " [U_Print] [bit] NULL,[U_View] [bit] NULL ";
SS = SS + " ) ON [PRIMARY] ";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "Alter Table LoanSanction ADD L_Known Varchar(Max)";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string SS = "CREATE TABLE [dbo].[AccountForeClosure]( ";
SS = SS + " [F_Id] [int] IDENTITY(1,1) NOT NULL, ";
SS = SS + " [F_SId] [int] NULL, ";
SS = SS + " [F_Date] [datetime] NULL, ";
SS = SS + " [F_Principal] [numeric](18, 2) NULL, ";
SS = SS + " [F_InterestRate] [float] NULL, ";
SS = SS + " [F_InterestAmount] [numeric](18, 2) NULL, ";
SS = SS + " [F_Previous] [numeric](18, 2) NULL, ";
SS = SS + " [F_Remarks] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, ";
SS = SS + " CONSTRAINT [PK_AccountForeClosure] PRIMARY KEY CLUSTERED ";
SS = SS + " ([F_Id] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]";
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
//========================================================================
try
{
string Path = "Finance_Management_System.SQL.Calculation.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string Path = "Finance_Management_System.SQL.AlterCalculation.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string Path = "Finance_Management_System.SQL.CashReceipt.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string Path = "Finance_Management_System.SQL.CashPayment.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string Path = "Finance_Management_System.SQL.AlterLoanApplication.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
try
{
string Path = "Finance_Management_System.SQL.AlterLoanSanction.sql";
Assembly A = Assembly.GetExecutingAssembly();
StreamReader D = new StreamReader(A.GetManifestResourceStream(Path));
string SS = D.ReadToEnd();
ObjDataAccess.ExecuteQuery(SS);
}
catch { }
//========================================================================
Application.Run(new Frm_Main());
}
public static void SendSMS(string P_Id, string MessageBody)
{
ClsDataAccess Obj = new ClsDataAccess();
try
{
string SSData = "Select a_mobile + ',' + a_mobile2 From AccountMaster Where A_id = " + P_Id + "";
if (Obj.GetDataTable(SSData).Rows.Count > 0)
{
string[] Mo = Obj.GetDataTable(SSData).Rows[0][0].ToString().Split(',');
for (int i = 0; i < Mo.Length; i++)
{
try
{
string MobNo = Mo[i].ToString();
MobNo = MobNo.Replace("(", "");
MobNo = MobNo.Replace(")", "");
MobNo = MobNo.Replace("+", "");
MobNo = MobNo.Replace("-", "");
MobNo = MobNo.Replace(",", "");
if (MobNo.Substring(0, 1) == "0" && MobNo.Length > 5)
{
MobNo = MobNo.Substring(1, MobNo.Length - 1);
}
if (MobNo.Trim().Length >= 10)
{
if (Program.SMSBY == 0 && Program.PortNo.Trim().Length > 0)
{
#region MOBILE
char[] arr = new char[1];
arr[0] = (char)26;
SerialPort sp = new SerialPort();
sp.PortName = Program.PortNo;
sp.BaudRate = 96000;
sp.Parity = Parity.None;
sp.DataBits = 8;
sp.StopBits = StopBits.One;
sp.Handshake = Handshake.XOnXOff;
sp.DtrEnable = true;
sp.RtsEnable = true;
sp.NewLine = Environment.NewLine;
sp.Open();
int mSpeed = 1;
sp.Write("AT+CMGF=1" + Environment.NewLine);
System.Threading.Thread.Sleep(200);
sp.Write("AT+CSCS=GSM" + Environment.NewLine);
System.Threading.Thread.Sleep(200);
sp.Write("AT+CMGS=" + (char)34 + "+91" + MobNo
+ (char)34 + Environment.NewLine);
System.Threading.Thread.Sleep(200);
sp.Write(MessageBody + (char)26);
System.Threading.Thread.Sleep(mSpeed);
sp.Close();
#endregion
}
else if (Program.SMSBY == 1)
{
#region WEB
string UserId = Program.UserId;
string UserPassword = Program.PasswordId;
string UserSenderId = Program.SenderId;
string Path1 = Program.Path1;
string Path2 = Program.Path2;
string Path3 = Program.Path3;
string Path4 = Program.Path4;
string Path5 = Program.Path5;
string Path6 = Program.Path6;
string Path7 = Program.Path7;
WebClient client = new WebClient();
string baseurl = Path1 + Path2 + UserId + Path3 + UserPassword + Path4 + UserSenderId + Path5 + MobNo + Path6 + MessageBody + Path7;
Stream data = client.OpenRead(baseurl);
StreamReader reader = new StreamReader(data);
string s = reader.ReadToEnd();
data.Close();
reader.Close();
#endregion
}
}
}
catch
{
}
}
}
}
catch (Exception Erp)
{
clsGeneral.ShowErrMsg(Erp.Message);
}
}